Aggregate lists across SharePoint sites in Project Online / Refresh PBI / Client authentication fail

[PetterR]

Dear all,

in the project specific SharePoint sites we have standardized decision logs, these need to be aggregated in a PBI report.

Facing the refresh issue of dynamic data sources in PBI service I luckily found Pat Mahoneys "Updated - Get SharePoint List Data...Fast".

I've put the second option into a function:

and I'm calling the function from my main query:

(note: here i'm explicitely querying for a static set of project names, blurred in the upper part)

Now, I'm facing the issue, that I can't refresh data in PBI desktopclient, as neither my admin nor my service account are accepted organizational level authentication.

Any ideas, where I'm wrong.

Thank you for your support.

Kind regards

Petter

[PetterR · Accepted solution]

Update: the structure above works and allows for aggregating list-data from a dynamic set of websites also in Power BI Service

My issue was that in the "Relative path"-option of "Web.Contents" a "/" was missing, fixed it and works like a charm 🙂

[PetterR]

Could you elaborate on the term "supplemental accounts"?

Normally using the service account ([name]@[domain]) works perfectly.

[lbendlin]

as neither my admin nor my service account are accepted organizational level authentication.

Might be worth checking if you are allowed to use supplemental accounts rather than service principals.