Forum Discussion
Help - Report Deadline - Group By Performance is Slow (Hours!)
Hi Txtcher ,
As mentioned by lbendlin , you can use Power BI's Power query to perform your transformations and use that M query in your excel.
Go to get data--> Blank query and paste it.
You will get your table
The you can just copy the table and paste it in the excel.Another way can be,
Use table visualization to export the data.Power BI is a very interesting tool and it has got many capabilities apart from transforming your data using Power Query.
Check this out to get started with Power BI.
https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started
Download from hereHope this helps!
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
Hi Txtcher ,
As mentioned by lbendlin , you can use Power BI's Power query to perform your transformations and use that M query in your excel.
Go to get data--> Blank query and paste it.
You will get your table
The you can just copy the table and paste it in the excel.
Another way can be,
Use table visualization to export the data.
Power BI is a very interesting tool and it has got many capabilities apart from transforming your data using Power Query.
Check this out to get started with Power BI.
https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started
Download from here
Hope this helps!
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
Well....I never knew there was a way to export from Power BI to Excel. I have searched and searched and never came up with a solution to do it. Probably because why would you do that? But I work for state government. They are very behind on technology. They want everything emailed in an Excel spreadsheet. Only a handful of employees even have Power BI.
Question: does Power Query in BI handle data aggregation differently than Excel? It is my understanding that Excel is loading everything to memory and that is why it takes so long to run. If Power BI does it the same way, that's okay. I can set up a model and write DAX to aggregate the data as needed. I am not very experienced at it, but I can probably muddle my way through it given enough time.
Thanks for the response.