Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I tried to follow the exact same steps as described in the post below by MSFT and get the below error .Can someone please guide .
Note: I havent made any change in the PS script except the query/datasetID.I am logged into powerBI as "me" and see the error.
Error
Invoke-PowerBIRestMethod : One or more errors occurred.
At line:25 char:9
+ $result=Invoke-PowerBIRestMethod -Url $requestURL -Method Post -Body ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod
Try a simple query first , EVALUATE a small table.
I had to completely uninstall all the Power BI Management cmdlets that have accumulated over the years and install the latest version. you may want to do the same.
I tried a lot of things but i got a different error now and not sure of the reason.I was able to run dataset refresh and GET methods but unsuccessful with this "executing of DAX"
Error:
Error is constantly pointing to something wrong at the client end request and i am not sure what more to fix.
Here is my code:
I tried the same with refreshes endpoint as below and the service principal was able to refresh the dataset.
# refresh
$uri = "https://api.powerbi.com/v1.0/myorg/groups/$GroupId/datasets/$DatasetId/refreshes"
Invoke-RestMethod -Uri $uri –Headers $headers –Method POST –Verbose
Note:
Thanks for your help.I already have a very simple evaluate query ,but I will definitely try to uninstall and reinstall the pbi cmdlets as you mention.
Hi @Anonymous
I think you can refer to this post with similar issue like yours. Try to move your dataset into V2 workspace. This user solved his issue by this way.
For reference: New API Endpoint with DAX Queries
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |