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).
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).
Hi ChielFaber Do you have the source(s) for your solution I'd like to do some reading up on it I have a dataset that appears to have the same issue.
i don't have a clear cut list of blogposts for you because I found it to be a not very common problem.. At least not a problem that's been written about. I've read a lot of blogposts, comments and discussions and didn't find one good solution. I read semi-related topics and put 1 and 2 together and tried different solutions. This ultimatly brought me to the solution.
Regarding the connectors I found this reply by bslattz :
https://github.com/MicrosoftDocs/powerbi-docs/issues/3703This made me try the legacy connector and that worked albeit very slow.
As a possible solution based on my knowledge I then the stopfolding code to refresh the dataflow. This also worked but it was also much slower than the original.
I've also used this. Not really related but it did help me find the solution regarding the admin rights to the gateway:
https://community.fabric.microsoft.com/t5/Service/Error-The-connection-you-are-trying-to-use-has-not-been-shared/m-p/1708184
