Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

OneDrive credentials only in personal mode Gateway?

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

Thank you

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous

      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's avatar
        Anonymous
        Not applicable
        8 years ago

        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