Create a data flow from an Online Sharepoint List

[webportal]

I'm trying to create a data flow from a Sharepoint list.

In Power BI Service, I tried creating a new entity, either by "Sharpoint list" and "Sharepoint online list". Once I type the URL of the site (NOT the URL of the list), like:

https://abc.sharepoint.com/sites/Projects

After signing in with my account, the preview returns an empty page, although this site has several SP lists.

How to fix this?

Thanks in advance for helping!

[nandukrishnavs · Accepted solution]

@webportal 

Try to connect the Sharepoint list from Power BI desktop.

1. Then go to Edit Query --> Advanced Editor 
2. Then copy all the queries from Advanced Editor
3. Go to Dataflow 
4. Select Blank query and paste the query which copied from Power BI desktop

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂