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.
Hello,
After creation and publishing of the new report faced with trouble of scheduled data refresh configuration:
You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.
Report has two data sources -> MSSQL and Excel file. (I never used Excel file as a source before)
Hi @mrslyfox,
Both data sources(MSSQL and Excel file) require a gateway(on-premises or personal) in order to refresh datasets on Power BI service. So you may need to install a new personal gateway or configure the data source for an existing data gateway(on-premises) in your scenario. For more details, you can refer to the following articles.
Regards
Hello @v-ljerr-msft
For the MSSQL I have on-premisse gw, but I do not want to refresh Excel data at PB service.
Exist a way how to disable it?
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.