Forum Discussion
Enabling Large models in Premium capactiy
Hi all,
I am attempting to enable Large models in my P1 capacity using the following tutorial...
https://docs.microsoft.com/en-us/power-bi/service-premium-large-models
... I am an admin of the workspace and followed the instructions. I am able to execute the Get-PowerBIDataset using my dataset ID and it returns Abf, as expected. When I attempt to execute the Set-PowerBIDataset command, I get a 400 Bad Request error. I added the -debug parameter. Please see the log below...
Set-PowerBIDataset : Operation returned an invalid status code 'BadRequest'
At line:1 char:1
+ Set-PowerBIDataset -Id 9b463f9a-9831-4aaf-9c6d-a01ef261cd35 -Workspac ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...tPowerBIDataset:SetPowerBIDataset) [Set-PowerBIDataset],
HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Data.S
etPowerBIDataset
VERBOSE: Request Uri:
https://api.powerbi.com/v1.0/myorg/groups/e6c92ab3-6db8-4e0b-8b98-e083a60d1994/datasets/9b463f9a-9831-4aaf-9c6d-a01ef26
1cd35
Confirm
Continue with this operation?
[Y] Yes [A] Yes to All [H] Halt Command [S] Suspend [?] Help (default is "Y"): Y
VERBOSE: Status Code: BadRequest (400)
Confirm
Continue with this operation?
[Y] Yes [A] Yes to All [H] Halt Command [S] Suspend [?] Help (default is "Y"): Y
DEBUG: 5:07:57 PM - Set-PowerBIDataset end processing.
Confirm
Continue with this operation?
[Y] Yes [A] Yes to All [H] Halt Command [S] Suspend [?] Help (default is "Y"): Y
PS H:\> Set-PowerBIDataset -Id 9b463f9a-9831-4aaf-9c6d-a01ef261cd35 -TargetStorageMode PremiumFiles
Set-PowerBIDataset : Operation returned an invalid status code 'BadRequest'
At line:1 char:1
+ Set-PowerBIDataset -Id 9b463f9a-9831-4aaf-9c6d-a01ef261cd35 -TargetSt ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...tPowerBIDataset:SetPowerBIDataset) [Set-PowerBIDataset],
HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Data.S
etPowerBIDataset
... any ideas?
2 Replies
To add to this, I ran Resolve-PowerBIError...
RequestId : f8ec7aeb-7350-4798-9f70-d81cbe09d459
Response : Bad Request (400): {"error":{"code":"InvalidRequest","message":"Invalid dataset. Premium Files is
not available for this dataset."}}
PowerBIErrorInfo :
ResponseDate : Wed, 22 Jan 2020 01:36:11 GMT
RequestMethod : PATCH
RequestUri : https://api.powerbi.com/v1.0/myorg/datasets/2d3e0a25-e6d5-4587-b0b4-48e4d8a3820e
InvocationInfo : {Set-PowerBIDataset}
Line : Set-PowerBIDataset -Id 2d3e0a25-e6d5-4587-b0b4-48e4d8a3820e -TargetStorageMode PremiumFiles
Position : At line:1 char:1
+ Set-PowerBIDataset -Id 2d3e0a25-e6d5-4587-b0b4-48e4d8a3820e -TargetSt ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
StackTrace : at Microsoft.PowerBI.Api.V2.Datasets.<UpdateDatasetByIdWithHttpMessagesAsync>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Api.V2.DatasetsExtensions.<UpdateDatasetByIdAsync>d__81.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Api.V2.DatasetsExtensions.UpdateDatasetById(IDatasets operations, String
datasetKey, UpdateDatasetRequest updateDatasetRequest)
at Microsoft.PowerBI.Common.Api.Datasets.DatasetsClient.PatchDataset(Guid datasetId,
PatchDatasetRequest patchDatasetRequest, Nullable`1 workspaceId)
at Microsoft.PowerBI.Commands.Data.SetPowerBIDataset.ExecuteCmdlet()
at Microsoft.PowerBI.Commands.Common.PowerBICmdlet.ProcessRecord()
HistoryId : 18... which gave me more insight on the 400 error... "Invalid dataset. Premium Files is
not available for this dataset."I am wondering what is missing in the *.pbix file? I have premium capacity set on my workspace and incremental refresh enabled with the right parameters. I have confirmed incremental refresh is working with a smaller amount of data.