I have a report that has gone through multiple revisions. Originally, I was using Google Sheets as a data source. Google Sheets turned out to be problematic so I changed the data source to a local workbook. When I did that, i removed Google Sheets as a data source by clearing it's permissions. I'm not currently using any Gateways as I'm just uploading this locally.
Since then, my report online does not always refresh. It keeps showing an outdated version.
I've tried adding Google Sheets back as a data source but i still have the same issue.
I get the error message:
Data source error: Scheduled refresh has been disabled due to at least one data source not having credentials provided. Please provide credentials for all data sources, and then turn scheduled refresh back on.
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: 9bcf056d-0dae-4edd-9bd2-cdf7442d7558
Request ID: 0f2913b9-afff-5c7a-c7fc-181b699cbd81
Time: 2018-05-01 14:57:15Z
The message though doesn't really tell me anything. Is there any insight you can provide?
I think there's some confusion. I'm not looking to create a scheduled refresh and I've never had to use a gateway before to publish reports to PBI online. I also don't have an existing gateway. I've always just been able to refresh reports locally.
This issue with Google Drive only recently started. Since then, I've basically had to negate using Google Drive altogether as a data source which is a shame because our company uses it frequently much as we try to get them to use Sharepoint.
In your scenario, it seems the data sources used in the report is local Excel files, right? To check all data sources, please go to Data source settings in Power BI desktop:
Then please go to dataset settings and find this dataset, check Gateway Connection and Data Source credentials sections. You can see below images, in my sample, the dataset connects to on-premise data source, so I configure dataset to use on-premises data gateway.
Thanks for the help. I haven't been using Gateways in general as I'm not currently working off an on-premise server. I've just been uploading locally to PB Online. This is the only report I have an issue with (and the only one I experimented with Google Sheets).
You can see in the images below that I just have the one local excel data source now.
Before adding / removing Google Sheets I wasn't getting this issue:
From the screenshot, the report get data from local Excel. The dataset also requires gateway on Power BI service.
1. You can use on-premise data gateway (personal mode).
2. You can use on-premise data gateway. Create a File data source points to Excel file in Manage Gateways, then set the dataset to use this data gateway.
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.