Power BI data flow: We could not evaluate this query due to invalid or missing credentials.

[webportal]

When trying to append two tables in a Power BI Dataflow on a Premium capacity, I get the error:

We could not evaluate this query due to invalid or missing credentials.

One of the sources is a flat csv file stored in SharePoint.

The other is a SQL server connection.

They both work perfectly, independently.

Can anyone help?

[HB_Hudson]

Hey guys ,

Can someone be kind and help me i have similar issue , i have excel files connected to sharedrive and i also ensured to create a Gateways for the same , when i am trying to access that gateways in dataflows i get the same error over and over ... it was working fine till yesterday and not sure what went wrong but this is not happening .

[Anonymous]

Just solved for me by amending the data type to Organizational on the 2 queries if you have access to the Gateway

[v-henryk-mstf]

Hi @webportal ,

The easiest way is to try to recreate this dataflow. Also see if a similar solution works for you:

Solved: Keep getting "unexpected error" when creating new ... - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and related operation screenshoots. Looking forward to your reply.

Best Regards,
Henry

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

[webportal]

Hi @lbendlin 

Yes, that's right. And the sharepoint Id is the same as power bi.

[lbendlin]

Ha, I remember!  We had a similar issue.  In this scenario you must use a gateway for your sharepoint data source even though technically it makes little sense.

[webportal]

@lbendlin 

That's right! That solves the problem.

Thank you!

EDIT:

Actually, it DOESN'T solve the problem.

Now, I get:

Unexpected error (Session ID: xxx Region: europe)

[lbendlin]

Same sensitivity/privacy level?