Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to build a Dataflow to extract data from over 400 SharePoint sites. Each site has multiple lists with identical structure. I was able to build the sites list dynamically, using SharePoint Search API.
From there, there are multiple options for accessing the data, by creating custom columns that could make API calls with OData.Feed() or Json.Document(Web.Contents()), or even using the SharePoint.Tables() method.
The problem is that this trivial step, that would have no problem working on PBI Desktop, is generating ONE AUTHENTICATION PROMPT PER SITE (Mind you, they're all subsites from the same root site).
In PBI Desktop, the authentication prompt would ask me to "Select which level to apply these settings to", at which point I'd select my org's main SharePoint site, and be done with it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.