Forum Discussion

lilyyan's avatar
lilyyan
Frequent Visitor
9 years ago
Solved

Gateway setting for Azure Data Lake Store and Sharepoint

I'm using Azure Data Lake Store and Sharepoint as data sources (I can connect to the server and refresh the data in PBI desktop), and now need to connect it in gateway.  How should I set it? I thoug...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    lilyyan,

    Do you connect to SharePoint online? If that is the case, as you connect to online data sources in your dataset, it doesn’t require gateway in your scenario. After you publish the Power BI Desktop file to Service, you will find “Connect Directly” in the settings for the dataset, just enter credential for your data sources and you will be able to set schedule refresh for the dataset.

    However, if you combine Azure data lake store and on-premises SharePoint data source in a single dataset, please install on-premises gateway(personal mode) and use it to refresh your dataset.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

lilyyan,

Do you connect to SharePoint online? If that is the case, as you connect to online data sources in your dataset, it doesn’t require gateway in your scenario. After you publish the Power BI Desktop file to Service, you will find “Connect Directly” in the settings for the dataset, just enter credential for your data sources and you will be able to set schedule refresh for the dataset.

However, if you combine Azure data lake store and on-premises SharePoint data source in a single dataset, please install on-premises gateway(personal mode) and use it to refresh your dataset.


Regards,
Lydia