Forum Discussion
Refresh Power BI datasets in certain workspaces using Powershell and API
Hi, I have managed to piece together the following code from a couple of different articles online to refresh all datasets within my organisations Power BI tenant however this takes over an hour to r...
why are you refreshing these datasets in the first place? Ideally they should only refresh when the source data has changed. What SKU are you running on?
The datasets are using Azure SQL databases but due to the Dynamic Row Level Security I applied so users and teams can access their own data I had to switch from Direct Query to Import mode. Which is why I need the dataset refresh automated rather than manually setting up the schedule on each dataset as there are far too many to go through.