Is there a reason why my permissions work when i look at a sharepoint list directly, and when i refresh a powerbi semantic model on desktop, but dont work when i try to refresh the same semantic model in service ?
I am an owner of the published workspace and have full build permissions.
The refresh was working without issues until late monday afternoon, yesterday it was failing in both service and on desktop, when i investigated, i could navigate to the Sharepoint list in the query, but no data was coming through, Powerquery could see the list, and the headers but none of the data.
Today, in the query on desktop the data is now visible, i've republished, but the online version still seems unable to see the records when i try refreshing.
Nothing has changed from my access levels perspective, i am still an owner, i still have full permisions on the sharepoint list, and my credentials are up to date.
Also worth noting i have other reports that are based on lists from the same sharepoint site, which use the same permissions, in the same workspace, which are fine, no issues... i am so confused!!!
