Forum Discussion
DataSource.Error: An error happened while reading data from the provider
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).
I managed to find two solutions to my problem. The problem seemed to only occur for the table that was connected through a linked table to the staging dataflow with a native.sql query.
When I change the connector from PowerPlatform.Dataflows to PowerBI.Dataflows the dataflow refreshes again. The second solution is to use the Table.StopFolding function on the source table.
What I find strange is that the connection used to work for months and the error only appeared a few days ago. \
As a consequence of the solutions the load time of the dataflow has increased.
I'm still trying to figure out the exact reason why the previous connector PowerPlatform.Dataflows stopped working. Does anyone of you have an idea?
Regards,
Chiel