Using table as a feed for a new query

[samdthompson]

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.

[samdthompson · Accepted 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.

[v-kelly-msft]

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!

[lbendlin]

@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.