Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @datavis ,
You could install the on-premise data gateway in Power BI Service without Premium license.
Best Regards,
Cherry
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
We have Power BI, not Power BI Premium. I think you have to have the premium version to use Gateway correct?
Hi @datavis ,
You could install the on-premise data gateway in Power BI Service without Premium license.
Best Regards,
Cherry