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.
Does power BI work better with tabular or multidimensional cubes? can i get all the data and relationships from the cube to PBI? and work with another source in the same report ?
Thanks
Solved! Go to Solution.
Hi @chaly10,
The Power BI Desktop, and all the modeling done in the tool is based on tabular. So it is a seemless transition between any development in the Desktop and what you may do in the model.
When using MD, Power BI is still using DAX to make calls to the MD cube, so there are some limitations and not all MD features may be supported.
Tabular (seems) to be where Microsoft is investing the vast majority of resources (based on the SQL 2016 release). It also has the potential to be much faster because it is (or can be) stored in memory, whereas MD is all on disk.
Another benefit (I'll be blogging on soon) is that you can directly connect your Desktop to the local in memory copy of the model when you are working on it. (looks like <modelname_YourName_GUID>) This is a huge development win for me, as I can test out my measures and calcs against the visuals right away prior to checking them in and deploying them.
If you are already well versed in DAX, my personal opinion is that you head down the tabular route.
Here is a similar thread about the same question, and the question was well answered there. Could you go to check if it helps?
Regards
Hi @chaly10,
The Power BI Desktop, and all the modeling done in the tool is based on tabular. So it is a seemless transition between any development in the Desktop and what you may do in the model.
When using MD, Power BI is still using DAX to make calls to the MD cube, so there are some limitations and not all MD features may be supported.
Tabular (seems) to be where Microsoft is investing the vast majority of resources (based on the SQL 2016 release). It also has the potential to be much faster because it is (or can be) stored in memory, whereas MD is all on disk.
Another benefit (I'll be blogging on soon) is that you can directly connect your Desktop to the local in memory copy of the model when you are working on it. (looks like <modelname_YourName_GUID>) This is a huge development win for me, as I can test out my measures and calcs against the visuals right away prior to checking them in and deploying them.
If you are already well versed in DAX, my personal opinion is that you head down the tabular route.
Here is a similar thread about the same question, and the question was well answered there. Could you go to check if it helps?
Regards
power bi model is a single ssas tabular model
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 | |
98 | |
79 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |