Value displaying in Pivot Grid, but debugger shows errors throughout all debug

[bernatagulloesbrina]

I'm trying to use debugger, so I built a pivot grid and used debug in one of the values however all the local variables measures show error all the way to the end, even though I do see a value in the pivot grid am I doing anything wrong?

https://user-images.githubusercontent.com/40455069/151019619-b12e6a40-8524-4682-9f21-fae835790b8f.mp4

[otykier]

Hi Bernat Which version of Analysis Services are you using? The debugger internally uses TREATAS, which is not supported on SSAS 2016 (will add that to the "current limitations" section of the docs).

[bernatagulloesbrina]

It was a pbix so latest Version of AS

El mié, 26 ene 2022 9:04, Daniel Otykier @.***> escribió:

Hi Bernat Which version of Analysis Services are you using? The debugger internally uses TREATAS, which is not supported on SSAS 2016 (will add that to the "current limitations" section of the docs).

— Reply to this email directly, view it on GitHub https://github.com/TabularEditor/TabularEditor3/issues/361#issuecomment-1021954856, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJUUXHLKHPSVZBWNKSAWNRLUX6TJPANCNFSM5MYYE4UA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>

[otykier]

Disregard my previous comment - I see now you're using Power BI Desktop, so it has nothing to do with TREATAS not being supported.

I suspect the filter on the pivot grid is being translated to DAX incorrectly by the debugger (that's where the TREATAS comes from). I'd like to look into it more. It would be helpful if you could share the .pbix in private or run a profiler/query trace against Power BI Desktop, and share the DAX that the TE3 debugger executes against the model.

[bernatagulloesbrina]

It's a real data pbix so I need to take the profiler route to share more with you. Do you have some guide of how to set it up? I think I've seen some tutorials, but I remember there's like a ton of settings depending on what you need

El mié, 26 ene 2022 9:11, Daniel Otykier @.***> escribió:

Disregard my previous comment - I see now you're using Power BI Desktop, so it has nothing to do with TREATAS not being supported.

I suspect the filter on the pivot grid is being translated to DAX incorrectly by the debugger (that's where the TREATAS comes from). I'd like to look into it more. It would be helpful if you could share the .pbix in private or run a profiler/query trace against Power BI Desktop, and share the DAX that the TE3 debugger executes against the model.

— Reply to this email directly, view it on GitHub https://github.com/TabularEditor/TabularEditor3/issues/361#issuecomment-1021959843, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJUUXHJBXDWJBKUXK3B4XSDUX6UEPANCNFSM5MYYE4UA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>

[otykier]

@bernatagulloesbrina easiest approach is DAX Studio. It'll capture all queries sent to the AS engine, including those coming from other tool:

1. Launch TE3, set up the debugging session
2. Launch DAX Studio
3. Start a trace from within DAX Studio
4. Jump around in the call tree in TE3 - each jump should generate a query that is captured by DAX Studio (in order to display the value of locals, watches, etc.)

[otykier]

I am also curious if you get the error without applying a filter to the Pivot Grid?

[otykier]

Hi @bernatagulloesbrina - do you have an update on this? A screenshot of the evaluation context stack and the filter on your pivot grid (the [MesAñoLargo] field) would be helpful.

[otykier]

Hi @bernatagulloesbrina - any updates on this? Thanks!

[bernatagulloesbrina]

I don't have the exact query that I did, but I tried another one and seems to be working fine even with complex measures, so probably was fixed in 3.2.1

thank you!

El lun, 7 feb 2022 a las 13:51, Daniel Otykier @.***>) escribió:

Hi @bernatagulloesbrina https://github.com/bernatagulloesbrina - any updates on this? Thanks!

— Reply to this email directly, view it on GitHub https://github.com/TabularEditor/TabularEditor3/issues/361#issuecomment-1031434819, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJUUXHLPE4TVPYVOZGBGLS3UZ653RANCNFSM5MYYE4UA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you were mentioned.Message ID: @.***>

--

Bernat Agulló

Partner & Data Enthusiast

@.***

+34 637 93 42 76

Balmes, 177

08006 Barcelona