PowerBI refresh using PowerShell bug

[rnian18]

Hello, I recently wrote a script in PowerShell to automatically update my datasets on PowerBI service.  After about 7-8 executions, the following error appears:

Invoke-PowerBIRestMethod : One or more errors occurred.
At C:\scripts\update_script.ps1:13 char:1
+ Invoke-PowerBIRestMethod -Url "datasets/5d802d ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod

I assume it is because I exceeded my 8 refreshes per day allowed on PowerBI because I only have a free account.  However, I am still able to manually click the refresh button on PowerBI Services.

So I am wondering if the error is caused by the 8 refresh limit.  And if it is, why is it still possible to manually refresh the data set?

Thanks!!

[GilbertQ · Accepted solution]

Hi there

I am not sure why that error is occurring, which could be because you have hit the refresh limit.

The way it works is you can only have 8 scheduled refreshes a day.

But you can manually refresh the datasets as often as you like.

[rnian18]

Yea, I assume it is from the 8 scheduled refreshes as well.

So for manual refresh, you can refresh the data set an infinite amount of times per day?  That's interesting, I think some online materials for PowerBI might be out of date! Thanks!