Good morning all,
I am hoping one of you great people can help or point me in the right direction.
I have a dataset that consists of 4 queries. One of the queries is called "test" and is a heavily manipulated version of the other 3 queries. How do i go about exporting the final heavily manipulated version of "test" into Excel?
All of the methods that I have tried so far, dont appear to export the data as per the final stage of Power Query:-
Using Get Data inside Excel - this imports the queries, but you have to recreate the column order
Analyze in Excel - this is similar as you have to recreate the data from a pivot
Ideally I would like to publish the the Dataset in PowerBI Online and have a scheduled refresh. I am hoping that multiple users can access the dataset online and just export the data into Excel?
Exporting into Excel doesnt seem as intuitive as excpected. Am i going about this wrong way? Do I need to create a dataflow?
Any help greatly appreciated,