Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
83 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
129 | |
108 | |
63 | |
55 |