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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
27 | |
23 | |
22 | |
16 | |
7 |
User | Count |
---|---|
33 | |
25 | |
18 | |
15 | |
13 |