Forum Discussion

Artie's avatar
Artie
Frequent Visitor
7 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    7 years ago

    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)

    Regards,

    Xiaoxin Sheng

  • Artie's avatar
    Artie
    7 years ago

    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.

    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!