Forum Discussion
Helper IAggregate lists across SharePoint sites in Project Online / Refresh PBI / Client authentication fail
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
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 🙂
3 Replies
PetterRUpdate: 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 🙂
- lbendlin
Super User
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.
- PetterR
Could you elaborate on the term "supplemental accounts"?
Normally using the service account ([name]@[domain]) works perfectly.
