Forum Discussion
Gateway_MashupDataAccessError When Running Refresh
Hello, I have a report with multiple data tables where the row size is ~ 25 million. These are wide tables, and I've created reports based off these data tables. When I load the report in desktop...
Hi newpbiuser01 ,
Based on your description, it seems that the issue is related to the size of the data table. While Power BI can handle tables with millions of rows, it’s important to ensure that your data source and gateway are properly configured to handle the volume of data you’re working with.
You may want to consider partitioning your data into smaller chunks to reduce the load on the gateway and improve performance .
You can refer to the following documentation to view gateway performance
Monitor and optimize on-premises data gateway performance | Microsoft Learn
Best regards
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly