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.
Hi all!
I ran in to a problem with one of my customers reports. They have a database onprem which i reachable through gateway. So far so good. Then they added data from an Office 365 Sharepoint List and here the problem starts.
The report can no longer be scheduled to run cause the sharepoint datasource is not configured in gateway. But no gateway is needed. If I try to configure a datasource in the gateway for SharePoint I cannot choose a SharePoint connector due to auth-methods.
Preferably I want to use gateway for onprem data and no gateway for Online sources, but cant find a solution for this.
Thanks in advance for your help!
Solved! Go to Solution.
If I recall, you should try using the Personal Gateway to resolve this (and I realize that doesn't make any sense).
Yes, this has come up a number of times. The issue is mixing on-prem and cloud-based data sources. Are you using the Personal or Enterprise Gateway?
We´re using the enterprise gateway.
If I recall, you should try using the Personal Gateway to resolve this (and I realize that doesn't make any sense).
As you say, doesn't make sense but works like a charm.
I'm happy with that solution. Thanks a lot!
No problem! Happy to help!
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.