Forum Discussion
Scheduled Refresh for two data sources
"I was wondering if it is possible to to enable a scheduled refresh when a dataset contains data from two sources; one from sql server and the other from an excel spreadsheet (which can be stored locally or in onedrive)."
Yes, we should be able to enable a scheduled refresh when a dataset contains data from two sources. I have tested it on my site(dataset with two data sources, one from sql server and the other from an excel stored on local), it works all fine.
"When i create the dataset in powerBI desktop and publish it to power BI, the Gateway connection is greyed out."
I have reproduced this issue too. The Gateway connection is greyed out because you haven't add the two data sources to your gateway. Here is the steps to add a data source to gateway from Power BI service.
After you add both the two data sources to your gateway from Power BI service, the Gateway connection will be enabled, and you should be able to schedule a refresh for the dataset.
Regards,
Hi Simon
when i try to add the sharepoint file as a data source (excel file using the url - https://xxxxxxxx.sharepoint.com/Shared Documents/xxxxxxx - Copy.xlsx) it tells me that its unable to connect due to invalid credentials, however they are the same credentials i used to connect to the same file via power BI desktop
I have tried a different approach aslo, and that is telling me i need a personal gateway (not enterprise). Are you able to assist
Thank you