Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have my SQL Server Analysis Services server where my cubes are located,
my question is,
as from power bi I can join the cubes already have the same characteristics and create a dashbord based on all the cubes.
Thank you.
HI @Juan-Power-bi,
What type of AS data source are you worked? Tabular or multidimensional cube?
If you mean tabular, current power bi allow you to use measure expression to calculate/design with live mode.
If you are work with the multidimensional cube, current edit features of calculating fields or expressions not availed on it. (For general visual and chart design based on fields, they work well on both two types)
Notice:
power bi data model is stored with AS tabular instance, it can be connected with AS multidimensional but not able to write expressions calculate based on its fields and structures. (data model not woks with multidimensional data source)
Regards,
Xiaoxin Sheng
@Juan-Power-bi , excat information would be helpful
refer if this can help
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-ssas-multidimensional
https://support.jetglobal.com/hc/en-us/articles/218952488-Connecting-Power-BI-to-OLAP-Cubes
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 35 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |