Forum Discussion

sdeepa1's avatar
sdeepa1
Frequent Visitor
2 years ago

An error happened while reading data from the provider

I am unable to refresh a report in Power BI Desktop, getting the following error.

 

Any idea what is causing this?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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