Forum Discussion
Exporting to Excel, data limit
Hi all, I work for a local government authority (so I cannot post any of the data here) but we have been using power BI to create tailored reports for data imported from other software via SQL. For ...
Hello AdamJay ,
What you could do is connect to your power BI dataset from excel and build the report you want using the data you have in Power BI.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
Hi, thanks for the response.
Unfortunately your suggestion would not work. We are working with so many tables and so much data that this would be virtually impossible to use excel as for source for data importing, which is why we started using Power BI.
We basically need to work out how much we can trust power bi’s data exports and if there is any way around these issues.