Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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).
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.