cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nmck86 Member
Member

Sharepoint Online

Hello,

 

I am trying to connect to sharepoint online and tons of different folders. However, each time it creates a custom function and that has created over 150 queries in query editor. Is there an easier way to connect to Sharepoint and pull in the data from folders? When I use regular folders it does all the transformations in one query and I am able to load the data just fine. Hoping someone can tell me how to do the same with Sharepoint.

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
nmck86 Member
Member

Re: Sharepoint Online

I was able to figure it out by adding a custom column that simply calls on the sharepoint dataset and brings back all the data in a table. This is on the Power BI tips page for folk to leverage through the below link:

 

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/ 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Sharepoint Online

HI @nmck86,

 

Nope, current power bi not support use one query table to generate multiple query tables.

You need to manually receive data from sharepoint folder and split them to different query tables with same category fields.

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
nmck86 Member
Member

Re: Sharepoint Online

I was able to figure it out by adding a custom column that simply calls on the sharepoint dataset and brings back all the data in a table. This is on the Power BI tips page for folk to leverage through the below link:

 

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/