Hi I need guidance on 1.What are the steps to be followed, considered for installing on premises gateway in a local sharepoint environment ? 2. What steps to be followed in the Mange Gateway in power bi service to automate refresh of datasets? Cheers CheenuSing

Hi Anonymous , It seems that your data source in power bi is from on-premises sharepoint. If so, you need to install the on-premises data gateway and then you could set the schedule refresh for this dataset in Power BI Service. You could install the on-premises data gateway in the server or the device which is always on and the server or the device is in the same domain with the device your sign in Power BI Service. In Power BI Service, you need to add your data source in data gateway under Manage data gateway like below. If you configure the gateway successully, you could go to Settings>>Dataset and find your dataset which need set schedule refresh, then you could select the gateway and set schedule refresh. If you still need help, feel free to ask. Here are the docuemnts you could refer to. Install on-premises data gateway set schedule refresh Best Regards, Cherry

Guidelines for setting on premises gateway in a share point environment

Forum Discussion

Related content

Assistance Required for Power BI Dashboard Refresh Configuration in On-Premises Environment

Data Environment Options Follow-Up

Data Environment Options

Environment File in Notebook

Best Practices for Medallion layers and Environments