Forum Discussion

romanovmv's avatar
romanovmv
Icon for Advocate I rankAdvocate I
5 years ago
Solved

Problems with Data columns with Live connection

Hi, I'm using Live connection to on-premises SSAS Tabular 2019 and have some issues with Data columns. It seems that Power BI cannot understand their data type (it's decimal) and cannot perform any ...
Need Help
  • romanovmv's avatar
    romanovmv
    5 years ago

    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's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

romanovmv 

It looks weird. These columns lack the ∑ symbol and are not recognized as able to be summarized, which caused this unexpected result. Do you use the latest Power BI Desktop? Does this occur only on decimal columns or on other numeric columns either?

 

Best Regards,
Community Support Team _ Jing Zhang