Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
In SSAS measures are showing like this
When i import measures in cube,its showing in tabular Format not as Power BI measures.
Please help me on this,why iit not showing as power bi measure
Solved! Go to Solution.
Hi @atul9063,
Please pay attention to the difference when importing measures from SSAS Mutidimensional cube into Power BI desktop with different ways.
Live connection to SSAS which loads the whole cube into desktop. This way, measures are formated as measures in Power BI.
Connect to SSAS with import mode. Import measures only. This scenario is similar to yours where SSAS measures are recognized as a normal field in Power BI desktop.
Connect to SSAS with import mode. Import measures and its related table/columns. As mentioned in this document, Measure groups in a multidimensional cube are exposed in Power BI as tables with the ∑ sign beside them in the Fields pane.
Best regards,
Yuliana Gu
Hi @atul9063,
Please pay attention to the difference when importing measures from SSAS Mutidimensional cube into Power BI desktop with different ways.
Live connection to SSAS which loads the whole cube into desktop. This way, measures are formated as measures in Power BI.
Connect to SSAS with import mode. Import measures only. This scenario is similar to yours where SSAS measures are recognized as a normal field in Power BI desktop.
Connect to SSAS with import mode. Import measures and its related table/columns. As mentioned in this document, Measure groups in a multidimensional cube are exposed in Power BI as tables with the ∑ sign beside them in the Fields pane.
Best regards,
Yuliana Gu
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |