Power BI failed to load only custom column from across multiple SharePoint site
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 result. The issue is that I can call and load only the default column but I also need the custom column. How can I do that? Anyone can help?
Here is the M code:
From here I can only load columns other than this custom column,