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.
Please remind me why I can connect to my OneDrive for Business only with Personal Mode?
Thank you
Solved! Go to Solution.
@Anonymous,
Do you have only OneDrive data source in your dataset? If so, no gateway is required to refresh your dataset.
However, if you combine OneDrive data source and other on-premises data sources in a single dataset, please review my replies in the following similar thread about how to set schedule refresh in this case.
https://community.powerbi.com/t5/Integrations-with-Files-and/PowerBI-Enterprise-gateway-You-don-t-have-any-gateway-installed/td-p/400922
Regards,
Lydia
@Anonymous,
Do you have only OneDrive data source in your dataset? If so, no gateway is required to refresh your dataset.
However, if you combine OneDrive data source and other on-premises data sources in a single dataset, please review my replies in the following similar thread about how to set schedule refresh in this case.
https://community.powerbi.com/t5/Integrations-with-Files-and/PowerBI-Enterprise-gateway-You-don-t-have-any-gateway-installed/td-p/400922
Regards,
Lydia
Thanks Lydia,
I do have both OneDrive for Business Excel file and on-premises SQL Sever DB as my sources.
I've read the thread...
So are you saying that the only way is to install the personal mode Gateway?
This is so strange.....
When is it going to be fixed?
Thanks
Michael
@Anonymous,
If you don't have merge or append query in your dataset, you are able to use on-premises gateway, otherwise, you can only use personal mode gateway.
Engineers are working on the issue that combine on-premises gateway with merger/append query. Once the issue is fixed, the idea will be updated.
Regards,
Lydia
Thank you Lydia,
I do Merge the datasources.
Looking forward for an update...
Thanks!
Michael
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.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |