cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Artie Frequent Visitor
Frequent Visitor

Expression.Error: The name 'PowerBI.Dataflows' wasn't recognized. Make sure it's spelled correctly.

Hi,

I did make up a report that uses a Dataflow called "fact_Sales". I was able to save it and publish it successfully.  However, when one of my peers tried to open it from his computer, he got this error: "Expression.Error: The name 'PowerBI.Dataflows' wasn't recognized. Make sure it's spelled correctly."

 

I thought it was a security issue, so the security report was cleared from this desktop. The credentials were refreshed but the error remained.

 

We created a blank query having Dataflows as the data source and it worked. We tried to copy/paste the M code generated from this new query into the old one, but it did not work (not sure if each query has hidden code). So at the end we build a new query that worked.

 

When I opened the report from my desktop, I got the same error. No changes were made to the report.

 

What may be driving this error?

 

Thanks.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Expression.Error: The name 'PowerBI.Dataflows' wasn't recognized. Make sure it's spelled correc

Hi @Artie ,

In fact, power bi desktop also require credentials to authorize and get correspond dataflow.
In query editor, it will direct invoke stored credentials to get correspond user id to find out workspace id and 'dataflow id' list.(obviously, these credentials not exist in other users' computers)

20.png

19.png

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Artie Frequent Visitor
Frequent Visitor

Re: Expression.Error: The name 'PowerBI.Dataflows' wasn't recognized. Make sure it's spelled correc

Hi Xiaoxin,

 

Thank you for the reply. I did try the Credentials refresh but it didn't work for me. Something that sounds weird to me is the expression "the name ... wasn't recognized", like if the source type didn't exist.

 

By doing some trials and errors, I found out that by going to the applied step "Source", then hitting Refresh Preview, somehow Power Query connects to the Dataflows.

Capture PB.PNG

We need to run the steps above each time the person who refreshes the report changes.

 

Perhaps not a scientific solution, but it worked.

 

Thank you!

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Expression.Error: The name 'PowerBI.Dataflows' wasn't recognized. Make sure it's spelled correc

Hi @Artie ,

In fact, power bi desktop also require credentials to authorize and get correspond dataflow.
In query editor, it will direct invoke stored credentials to get correspond user id to find out workspace id and 'dataflow id' list.(obviously, these credentials not exist in other users' computers)

20.png

19.png

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Artie Frequent Visitor
Frequent Visitor

Re: Expression.Error: The name 'PowerBI.Dataflows' wasn't recognized. Make sure it's spelled correc

Hi Xiaoxin,

 

Thank you for the reply. I did try the Credentials refresh but it didn't work for me. Something that sounds weird to me is the expression "the name ... wasn't recognized", like if the source type didn't exist.

 

By doing some trials and errors, I found out that by going to the applied step "Source", then hitting Refresh Preview, somehow Power Query connects to the Dataflows.

Capture PB.PNG

We need to run the steps above each time the person who refreshes the report changes.

 

Perhaps not a scientific solution, but it worked.

 

Thank you!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 543 members 4,403 guests
Please welcome our newest community members: