I have a SharePoint List (in a Team) which is the data set for a Power Bi Report (desktop) which lives in the same Team, which then gets published to a workspace which the Team has access to. I tried to keep everything in the same space to try to make it easier.
My problem is that when the List gets updated, it does not refresh the data set in the workspace. I have to open the Report in Desktop, Refresh and then Publish for the Workspace data set to update.
I've tried to do a Power Automate, but I can only link the SharePoint List to the Workspace dataset. Which doesn't work because it misses out the middle Report step.
Does anyone know any automation or connectors which would link these steps?