Facing issue while connecting PowerBi with One drive

[bhavadharani]

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 🙂

[lbendlin]

Use the SharePoint Folders connector, not the Web connector.

[bhavadharani]

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]

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.

[bhavadharani]

Hi @lbendlin 
I tried connecting using sharepoint folder, but I got this issue.
How to clear this issue @lbendlin 

Note: I am using Personal sharepoint not a team.

Thanks in advance.. 🙂