Forum Discussion
Connect SSAS in Import
Hello,
I would like to connect in Import to an OLAP SSAS Cube on Power BI.
When I connect directly, no problems. I have found my modeling and my measurements. However the limitations do not allow me to have a composite data model. So I cannot create or connect to new tables.
When I want to connect in import, I no longer have my modeling or my measurements.
Is this normal? How to get around?
Thank you
Hi DGTL ,
When you choose import mode to connect SSAS, measure groups in a multidimensional cube are exposed as tables with a sigma (ā) beside them in the Fields pane. Calculated measures without an associated measure group are grouped under a special table called Measures in the tabular metadata.
For further information about SSAS, you can refer the following Microsoft documents that could help you:
- https://docs.microsoft.com/en-us/power-bi/desktop-ssas-multidimensional
- https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi DGTL ,
When you choose import mode to connect SSAS, measure groups in a multidimensional cube are exposed as tables with a sigma (ā) beside them in the Fields pane. Calculated measures without an associated measure group are grouped under a special table called Measures in the tabular metadata.
For further information about SSAS, you can refer the following Microsoft documents that could help you:
- https://docs.microsoft.com/en-us/power-bi/desktop-ssas-multidimensional
- https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.