Hi @sdeepa1,
I understand that you’ve encountered an error while attempting to refresh a report in Power BI Desktop. To assist you more effectively, I would appreciate if you could provide the following information:
- Could you specify the data source to which you are connected?
- What connection mode are you utilizing?
- Have you been able to successfully refresh the report in the past?
- Have there been any recent modifications to this report?
The following one is the thread which have the similar problem as yours, hope they can help you.
Solved: DataSource.Error: An error happened while reading ... - Microsoft Fabric Community
The above solution does work albeit with a negative impact on the performance due to stopping the query folding opportunities.
While searching further on the internet I found a solution that works and it's really simple, but it also feels a little strange. For the query folding principle to keep working witht the PowerPlatform.Dataflows connector it appears that you need admin rights to the gateway. When I asked our PowerBI admin to give me admin rights on the gateway the issue was resolved and our dataflow load time went back to expected (20 minutes instead of 2 hours).
Best Regards
