Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
27 | |
17 | |
16 | |
8 |
User | Count |
---|---|
45 | |
38 | |
34 | |
18 | |
15 |