Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
webportal
Impactful Individual
Impactful Individual

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

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?

7 REPLIES 7
HB_Hudson
New Member

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 .

 

HB_Hudson_0-1711887369607.png

 

Anonymous
Not applicable

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

 

pelleeds1980_0-1653994236749.png

 

v-henryk-mstf
Community Support
Community Support

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
Impactful Individual
Impactful Individual

Hi @lbendlin 

 

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

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
Impactful Individual
Impactful Individual

@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
Super User
Super User

Same sensitivity/privacy level?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors