topic Re: Get-PowerBIDataSet Error in Developer

Get-PowerBIDataSet Error

Aaronasp — Wed, 06 Dec 2023 20:15:59 GMT

The below the lines of code are part of one of my powershell scripts and it was working until this week when I starter to get an error (see below):

Code:

$datasetName = (Get-PowerBIdataset -Id $datasetID -Scope Organization).Name
if ( [string]::IsNullOrEmpty($datasetName)){
write-host "UNKNOWN - Could not find the requested dataset!"
exit 3
}

Error:

Get-PowerBIdataset : A task was canceled.
At E:\PowerBI\scripts\nagios-check-refresh.ps1:131 char:17
+ ... asetName = (Get-PowerBIdataset -Id $datasetID -Scope Organization).Na ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...tPowerBIDataset:GetPowerBIDataset) [Get-PowerBIDataset], TaskCanceledException
+ FullyQualifiedErrorId : A task was canceled.,Microsoft.PowerBI.Commands.Data.GetPowerBIDataset

I tried a lot of ways to avoid this but the Get-PowerBIDataSet is not returning any value when I pass the $datasetid and I confirmed it's valid and the user is an admin.

Not sure if this is related to the update on the Power BI to the dataset that are not longer called in that way but Semantic Model, please advise about any possible solution.

Re: Get-PowerBIDataSet Error

Anonymous — Fri, 08 Dec 2023 02:28:36 GMT

Hi @Aaronasp ,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Get-PowerBIDataSet Error

Aaronasp — Fri, 08 Dec 2023 13:10:51 GMT

I tried to get the name of the dataset using the datasetID in this line:

$datasetName = (Get-PowerBIdataset -Id $datasetID -Scope Organization).Name

but apparently the Get-PwerBIdataset is not working anymore because is returning the error I posted above, no matter how I change that never return the value and that was working just fine until this week.

Re: Get-PowerBIDataSet Error

Anonymous — Tue, 19 Dec 2023 09:52:03 GMT

HI @Aaronasp,

Have many times you test with these API? AFAIK, current tenant/capacity existed limitation process the request and they will block/cancelled if too many requests sent.
In addition, how long did this request processed? If the current request execute too long times power bi service will also cancel the request.

Regards,

Xiaoxin Sheng

Re: Get-PowerBIDataSet Error

Aaronasp — Tue, 19 Dec 2023 15:10:03 GMT

how this can be a solution, this is a joke, nothing that you mentioned make any sense, there is no limitation on nothing, I found a work around that but stop posting things that doesn't help at all, thanks for nothing