Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
13 | |
12 | |
12 |