Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables.
AzureSQL_Table1
SQLServerLocal_Table1
If I upload my dataset, then to refresh from the service, I need a data source in the data gateway for SQLServerLocal_Table1, but not AzureSQL_Table1.
That's expected behavior.
If I merge in one column fromSQLServerLocal_Table1, onto AzureSQL_Table1, then suddenly the Azure SQL source is asking for an entry in the data gateway.
Is that because the merge will happen on the gateway, not the service, or?
Solved! Go to Solution.
Yes. When you mash up data (merge, append, etc) cloud and on prem data, you need to allow the gateway to access those cloud data sources as shown below from the gateway config in the Power Platform admin panel.
If you are just pulling in the tables directly and not merging, this would not be necessary.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYes. When you mash up data (merge, append, etc) cloud and on prem data, you need to allow the gateway to access those cloud data sources as shown below from the gateway config in the Power Platform admin panel.
If you are just pulling in the tables directly and not merging, this would not be necessary.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.