Forum Discussion
Advocate IProblems with Data columns with Live connection
I've figured out why that happened: there was a setting discourageImplicitMeasures set to be true in the on-premises Tabular model. Should have probably turned it on while experimenting with calculation groups. Problem is solved now.
Advocate IHi v-jingzhang and amitchandak ,
I use the latest version of Power BI Desktop with clean cache.
I think it's not a problem of Power BI, but the problem of MS SSAS Tabular (or maybe both). I've tried to connect to the same model from Excel and PBI Service but got the same result.
Interesting thing is when I've started to build the same Tabular model again from scratch - it worked fine. So what I'm planning to do now is to finish that new model so that it fully replicates the existing one step by step and try to capture which table (or measure, or relashionship, etc) causes this bug. I'll updated you with the result of my experiment.
Thanks,
Misha
Community Supportromanovmv Thank you for this info. Hope your experiment goes smoothly.
- romanovmv
I've figured out why that happened: there was a setting discourageImplicitMeasures set to be true in the on-premises Tabular model. Should have probably turned it on while experimenting with calculation groups. Problem is solved now.
- v-jingzhang
Thank you very much for this update. I believe it will help people who have similar problem.
I found an article about this setting and its limitation with Power BI for anyone who might want to refer to: https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#limitations