Forum Discussion

Izs's avatar
Izs
Frequent Visitor
3 years ago

Power BI failed to load only custom column from across multiple SharePoint site

Hallo,   I have more than 5 SharePoint online sites and it continually growing. I use the “Web.Contents” method to call the Sharepoint Search API and then the “Json.Document” method to parse the re...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Izs ,

 

Before we import the data to Power BI from a data source, we usually use Power query editor to filter the useless data to enable them from loading into the Power BI, you can check these two documents:

Learn How to Filter Records Using Power Query

Filter data (Power Query) - Microsoft Support

You can also use query parameter to filter your table. More details about query parameter, please refer to: Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI.

 

If you want to filter data before the data has been imported into PBI, you can click Get Data->advanced options and write some SQL statements to achieve data you want when connecting to SQL Server.

For connecting to SharePoint is currently impossible.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Izs's avatar
Izs
Frequent Visitor
3 years ago

Hi Stephen,

 

Tq for your reply but I'm not trying to connect to the SQL server for some reason. 

I try to solve it by using a "Web.Contents" to get data from across multiple SharePoint sites.

 

My current code can pull the default column from multiple SharePoint sites but the custom column returns "null". Despite having data. eg: Custom Risk & Issue data in Project Online

 

How can I do that? 

 

Tq.