Forum Discussion
Salesforce Refresh
Hi PaulCo,
You combine online data source(Salesforce) and on-premises data sources(Excel file) in a single dataset, please install Power BI personal gateway and enter credentials for each data source after configuring personal gateway in your dataset following guide in the article below, this way, you will be able to set schedule refresh for this dataset.
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-4-6-install-configure-personal-gateway/
Thanks,
Lydia Zhang
Thanks for your assistance,
Here is the screenshot of the reports settings. The Data source Credentials is greyed out. When I go to the settings of the other dataset which I set up on the Power BI website using the SFDC content pack I can schedule a refresh but not for the one I created in the Deesktop application.
Thanks
Hi PaulCo,
Do you combine multiple data sources in your dataset in Power BI Desktop? Could you please post a screenshot of your data sources in Power BI Desktop? You can go to File -> Options and settings ->Data source settings to check data sources for Power BI Desktop.
In addition, you don't have to re-create all reports in Power BI Service. If you combine mutiple data sources in a dataset, make sure the personal gateway is online and you are able to use the gateway to refresh your dataset.
Thanks,
Lydia Zhang