Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |