Power Apps Dataflow Mashup script Datasource Credentails Issue

[Syndicate_Admin]

Hi ,

I have two source 1) on premises sql database ( Gateway connection is already setup ) 2) Table in Dataverse.

I'm trying to bring both sources in Dataflow in Power Apps and it’s giving me error saying my credential are invalid.

I have checked if i connected them individually its working but when the query is mashup i.e., bringing data from two sources it gives me that error on the credentials.

[Syndicate_Admin]

Hi All, 

I have two datasources , and I can only select one project options , either datagateway for on-premises or none for the dataverse. I can select individually. 

[Anonymous]

Hi @Syndicate_Admin ,

1. Check the box in the gateway settings to allow the user's cloud data sources to be refreshed through this gateway cluster.

Merge or append on-premises and cloud data sources

Best Regards,
Gao
Community Support Team

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 in the Power BI Forum