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 some data loaded in power query which I have shaped and fed back to a table in powerBI. Once there I have applied some DAX. I now want to use that table as a datasource to feed it back to power query and do a final transformation. Is that possible?
Before you ask, yes the DAX transformations need to be done as the power query alternative was way too slow (Creating a ragged heirarchy) and the DAX is not able to unpivot the result in the way I want in an efficient way.
Solved! Go to Solution.
Yeah, this workss nicely. Good thinking.
the why is that my ragged hirarchy has a top level of 2500+ with a near exponential rate through 12 generations but still growing. I tried using a power query function but it cycled through one record at a time. I tried using DAX to do a calculated table of what i wanted to do but the calulation time was although much faster, still too slow. Using power query to split and unpivot DAX results based on =PATH & =PATHITEM is about 22 time faster than the calculated table method and literally 100's of time faster than the custom function method.
Yeah, this workss nicely. Good thinking.
the why is that my ragged hirarchy has a top level of 2500+ with a near exponential rate through 12 generations but still growing. I tried using a power query function but it cycled through one record at a time. I tried using DAX to do a calculated table of what i wanted to do but the calulation time was although much faster, still too slow. Using power query to split and unpivot DAX results based on =PATH & =PATHITEM is about 22 time faster than the calculated table method and literally 100's of time faster than the custom function method.
Hi @samdthompson ,
Thanks for your additional clarification, indeed, there are pros and cons to dax and power query.
Could you pls mark your reply as answered to let more people find the solution?
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
@samdthompson (putting aside the urge to say "Why?" )
Once you have published the Power BI file to a workspace (and thus created a dataset) you can then connect to that dataset from Power Query.
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 |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |