Dataflow Failed refresh: The exception was raised by the IDataReader interface.

[TMO_KY]

Hey Y'all, I know this error has been mentioned several times but none of the answers are specific to my scenario so any help would be appreciated.

Here's the error: Data source errorDataflowUnauthorizedError. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. 

Now the background of what I have going on, I have a bunch of dataflows that pull from Sharepoint (thousands of excel files) and Salesforce.  I did this to speed up the refresh process since there's a ton of data.  The dataflows all refresh fine with absolutely no issues, see screenshot:

All dataflows refresh fine

Now when I build my PBIX file in desktop, I link to the dataflows and it refreshes perfect with no errors or issues and MUCH quicker since I'm using dataflows,  But as soon as I publish the PBIX file to Service and set automatic refresh is when I get the failure: Data source errorDataflowUnauthorizedError.

I've checked the credentials in Service and it says everything is fine:

Now I've tried changing Privacy level to Organization and None and it still seems to fail.  I do not have any merged queries, I have one using the Append but no Merge (fuzzy), I read that was one person's issue.   Any help would be greatly appreciated.  I don't want to go back to the old way of pulling the data because I was getting the Sharepoint Timeout errors and Dataflows make it super effecient in the desktop to make tweaks and showcase to upper management.

[ReportMaster]

Hi @TMO_KY I think in this case even a dataflow is not needed for a SF data source. As a workaround, maybe you can try with an external connector. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options.

[v-robertq-msft]

Hi, @TMO_KY 

I think you can check and guarantee the Privacy level of the dataset in your Service to keep the same as the Privacy level in the desktop, which may cause the scheduled refresh failure, like this:

Understand Power BI Desktop privacy levels

Privacy Levels for Cloud Data Sources

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TMO_KY · Accepted solution]

@v-robertq-msft   Thanks for your reponse.  It ended up being the different workspace capacity levels.  Dumb in my opinion but the dataflows are housed on a Premium Capacity (trial) and the reports/dashboards are housed on a normal workspace capacity.  You would think they would still "talk" to eachother.