Refresh Failed: How to refresh table join between on-prem and cloud datasource Power BI?

Refresh Failed: How to refresh table join between on-prem and cloud datasource Power BI?
Power BI Datasource Refresh Issue for On-Prem and Cloud Datasource Join or Merge: COM error: Microsoft.PowerBI.AS.ConnectionDetailsProvider, Refreshing cloud & onprem datasources, but the gateway doesn’t allow cloud datasource refresh..

Key takeaways:
Use the on-premises data gateway to merge or append on-premises and cloud data sources in the same query.
How to referesh table joined from on prem SQL-Server and dataflow in cloud service?
Merge or append on-premises and cloud data sources

Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud

Chapters:
0:00 Start
00:10 Data Refresh Issue in Power BI
01:10 Open Gateway Settings
01:31 Settings Option for Data Refresh Issues
02:15 Subscribe!

#PowerBI #DataGateway #PowerBIService #RefeshFailed #PowerPlatform #PowerAddicts #Digitaldhruvin #Dhruvinshah

Leave a Reply

%d bloggers like this: