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.
Good day Power BI Community.
Question, what do you think about designing, creating and implementing a Shared Dataset as a Cube versus an SSAS Cube ?
I read the article entitled "Power BI Shared Datasets versus Cubes" from the URL link below:
https://www.onesixsolutions.com/blog/data-analytics/shared-datasets-vs-cubes/
I would love to know your thoughts on this.
Thank you.
Solved! Go to Solution.
Hi
Did You move to Power BI datasets instead of using SSAS tabular cube and what was the trade-offs?
I am looking into move to SSAS for several reasons. The PowerBI Pro licens is a shared space between companies making the power to refresh and calculate measures be very controlled by the amount of power available to You at the time. That also means that I am potentially looking into upgrade to a premium version for all users and that is still not enough power vise.
So did You move to datasets or stayed with SSAS?
Hello Bokazoit.
Yes I went ahead and created a Power BI dataset modeled with data coming from Microsoft Dynamics 365.
Each user that had access to the data set had a Premium Per user License.
Once you have a properly designed model everything will be fine.
If you think the the Premium Per user License is not enough for you, you can use the Premium Capacity License.
I am still usin the Power BI Dataset.
kind regards,
Hi @rthomas_jbg
The Power BI Shared dataset is actually also a cube. It is just hosted and mainted by the Power BI team.
If you can get it working within the shared dataset then that is what I would suggest doing.
Hi @GilbertQ
Thank you very much for responsing to my post.
Bsaed on your response to my question, are saying that for example, I can connect to Microsoft Dynamics 365 using Power BI and then design, create and implement a model (Shared Dataset) that can be served as a cube to which the business users can connect ?
Hi @GilbertQ
Thank you very much for you responses to my questions.
I truly appreciate it.
Kind regards,
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.