OneDrive credentials only in personal mode Gateway?

[Anonymous]

Please remind me why I can connect to my OneDrive for Business only with Personal Mode?

Thank you

[v-yuezhe-msft · Accepted 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]

@v-yuezhe-msft

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

[v-yuezhe-msft]

@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

[Anonymous]

@v-yuezhe-msft

Thank you Lydia,

I do Merge the datasources.

Looking forward for an update...

Thanks!

Michael