Forum Discussion

bhavadharani's avatar
bhavadharani
Helper I
2 years ago

Facing issue while connecting PowerBi with One drive

Hi...Hope all are doing good 
 My Requirement, Is to connect Onedrive(I have the root URL like https://[organization]-       my.sharepoint.com/personal/[username]_domain_com/EQ9A7WQZza9LuFkPCmy_o4Bzyjqy6jwwgi7LvdhYKsPcA?e=TesXIR) with   PowerBi. I tried it my connecting via GetData->web. It's connected but 

 I just got HTML Code and displayed test (like above attachment).  I tried to transform the data(Transform data) as it has table, but   it displayed a empty data. 
 I tried a lot, but I couldn't find a solution to my problem.
Please help me to solve my problem
Have a good day. Thanks in advance 🙂

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Use the SharePoint Folders connector, not the Web connector.

    • bhavadharani's avatar
      bhavadharani
      Helper I
      2 years ago

      Hi lbendlin,
      I tried using sharepoint folder as well, but I couldn't connect it. Could you please guide me to find out where did I miss. Could you please provide me a step by step procedure to connect via sharepoint folder.
      Thanks in advance 🙂

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Connect to SharePoint Folder, use

         

        https://[organization]-my.sharepoint.com/personal/[username]_domain_com

         

        as the Site URL. Authenticate via OAuth2.  Then navigate to the file you want to ingest.

         

        Note:  It would be better to use a team sharepoint rather than your personal one.