Dataset refresh failure - Dataflow is the source

jcampbell474 · ‎03-07-2022

I can refresh my dataset from the dataflow all day long on my desktop. But, if fails almost instantly once published.

Of course, the message seems rather vague: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":

I removed and reinstated the gatway entry and connection. It is mapped to dataflows.

Don't know if it's related, but for some reason if I use the Power BI Dataflows connector, the workspace doesn't appear so that I can select it. If I choose the newer Dataflows, it is visible in my environment.

Has anyone ran into this? If so, any guidance will be appreciated.

Anonymous · ‎03-10-2022

Hi @jcampbell474 ,

Please consider sharing more details about it. For example, what is the data source of the dataflow and where is it stored? Which connector are you using to connect to the dataflow?

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

jcampbell474 · ‎03-10-2022

Okay. Think I figured it out. Will you please confirm?

The Power BI Dataflow connector will use the gateway no matter the credentials used. In other words, the account in the pbix doesn't have to match the account in the gateway (dataflow) entry.

The (PowerPlatform) Dataflow connector will only use the gateway (when published to the service) IF the accounts match.

We do not like this requirement as both accounts have the necessary access/permissions.