Solved: Gateway setting for Azure Data Lake Store and Shar...

lilyyan · ‎07-18-2017

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 though it should be ODBC, but failed as below. Is the type wrong or anything else wrong? (BTW, I tried Authentication method "Basic" and "Windows", both failed with same details).

Anonymous · ‎07-19-2017

@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

View solution in original post

Anonymous · ‎07-19-2017

@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