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.
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
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |