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.
Hi @bali1879 ,
I think you are work with an online folder, right?
If this is a case, current power bi gateway does not support handle cloudy datasource, you can turn on 'Allow user's cloud data sources to refresh through this gateway cluster' option to use gateway mangel this online datasources.
Merge or append on-premises and cloud data sources
BTW, please not do the merge and combine operation between on-premise data source and online data source. (it will cause the issue when power bi verify the credentials of mixed data table)
Regards,
Xiaoxin Sheng
I've linked an Excel file in the Sharepoint with a Sql db. I have done the Merge in the Query builder and it looks good.
The issue comes when I try to refresh the report in Power BI Service.
The scope of work is to link the data from the db in the Excel file.
HI @bali1879 ,
I 'd like to suggest you remove merge steps to confirm if the refresh issue is related to merge steps. If this is a case, you can do merge steps in your excel file and use power bi to get merged data from excel file.
Regards,
Xiaoxin Sheng
Covering 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.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |