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.
Hello, I have basically made a model on both power query and power bi.
I've got 700k lines so power bi dax would be quite faster and probably more useful for me, since power query takes between 7 and 10 minutes to load the data.
However, my question is... since the end goal of this is making some complex charts to replicate the existing ones which management is used to look at and:
I cant replicate those charts on power bi because it is an hassle to add grand totals for example and other stuff
Power bi data cant be converted into a pivot table (at least automatically or in the means of a cube. (Or can it?)
Should I just keep going with power query, cos since it's already done and even though it was more time consuming to build than power bi, it is the only alternative to me. Or is there ways to:
Convert data into a query somehow
Create a cube connection to automatically make pivot tables in excel?
I hope I made my doubts clear. Thank you
@haloboyscp , Difficult to guess what you are looking for, but these should help
https://radacad.com/m-or-dax-that-is-the-question
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
https://radacad.com/pivot-and-unpivot-with-power-bi
https://www.thebiccountant.com/2015/08/12/how-to-pivot-multiple-measurescolumns-in-power-query/
https://www.sqlbi.com/articles/comparing-dax-calculated-columns-with-power-query-computed-columns/
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |