Refresh from various data sources

[datavis]

I have a file with 6 dashboard tabs. Some of the tabs have data that updates daily from SharePoint and other tabs have data from Excel that are manually updated monthly. Can you publish this report and manually update the monthly data without interfering with the SharePoint automatic daily updates?

[v-piga-msft]

Hi @datavis ,

If I understand your sceanrio correctly that you have the combine data source in your pbix and you want to manually refresh the excel data monthly and let the SharePoint data automatic daily updates when you publish the report in Power BI Service?

We could do that via data gateway in Power BI Service.

To refresh the excel data, you should add the excel data source in data gateway then you could manually refresh the dataset.

For SharePoint online source, it will update automatically.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[datavis]

We have Power BI, not Power BI Premium. I think you have to have the premium version to use Gateway correct?

[v-piga-msft · Accepted solution]

Hi @datavis ,

You could install the on-premise data gateway in Power BI Service without Premium license.

Best  Regards,

Cherry