Forum Discussion
webportal
Impactful Individual
Impactful IndividualCreate a data flow from an Online Sharepoint List
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/ProjectsAfter 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!
Try to connect the Sharepoint list from Power BI desktop.
- Then go to Edit Query --> Advanced Editor
- Then copy all the queries from Advanced Editor
- Go to Dataflow
- 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 🙂
1 Reply
- nandukrishnavs
Community Champion
Try to connect the Sharepoint list from Power BI desktop.
- Then go to Edit Query --> Advanced Editor
- Then copy all the queries from Advanced Editor
- Go to Dataflow
- 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 🙂