Sharepoint Online

[nmck86]

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!

[nmck86 · Accepted solution]

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/ 

[v-shex-msft]

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