Forum Discussion
Visual table download misses data
Hi almay ,
In Power BI Desktop, you'll only have the option to export summarized data.
The solution is to create an index column or other unique column so that the data is not summarized, or filter the data in the query editor and copy the table and paste it into excel.
If it's in service, make sure the pbix file "allow users to export underlying data sources" is enabled in desktop. And make sure that "export data" is set up correctly in the service admin portal, and whether the user has edit permission or build permission on the dataset in the workspace.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yup, once I enabled "Allow users to export underlying data sources", the full report was downloadable. I dont even understand why sujmarised data download option is there, it seems to be creating more problems than it solves.
Many thanks