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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Syndicate_Admin
Administrator
Administrator

Power Apps Dataflow Mashup script Datasource Credentails Issue

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.

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

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
Not applicable

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.

vcgaomsft_0-1677725177743.png

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors