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.
Hi Experts,
I have been learning power query, power pivot and power BI. I’m now trying to tie everything together. The end game is I want to publish a Power BI dashboards.
I have built a mock up dashboard with 2 tiles:
The first item can be built in power BI directly from the data. No problem here.
The second tile require some data modelling. It can be done in power BI using add new measure. Column M is the end result and is summarized in Power BI to 0,5 (shown for illustration purposes).
(The modelling contains two "IF" formula and two simple "+" and "*" formulas. )
I’m in doubt if this is the correct approach and if good practice is to do data modelling in excel/power pivot. I actually have a preference for doing the modeling in excel since it is calculation “on top” of calculation to get to the correct data.
So here are my questions:
Should the last item be calculated in Power BI or first in Excel and why?
When does data need to be calculated first in Excel instead of directly in power BI using a “new measure”?
Is it “OK practice” to have the same underlying data for tile 1,2 above where one is put directly into Power BI where the second tile is routed first to excel for some additional calculations?
Solved! Go to Solution.
Hi @Anonymous,
Almost no difference,It's just that some DAX functions can't be used in power bi.
When you import power pivot into the power bi desktop, the refresh will still synchronize with power pivot.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickl
Ok @V-lianl-msft , so I assume you mean that my example should be done directly in power BI. Could you give an example where you would first do some calculations in excel?
Hi @Anonymous ,
Power Pivot is a calculation engine for pivot tables.
We can use Power Pivot in either Excel or Power BI.
If you're doing it in power bi you just need connect excel, if you're doing it in excel you need to import the power pivot model.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |