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.
Hello, i hope you´re doing well.
I´m having this issue every time i try to modify credential of the Dataset.
Invoke-PowerBIRestMethod : One or more errors occurred.
At C:\Users\ZN661HL\source\repos\ImportantStaff\CICD\ModifyDatasetCredential.ps1:61 char:16
+ ... $response= Invoke-PowerBIRestMethod -Url "gateways/$($BounGateway.va ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod
This is the Code i´m using:
Solved! Go to Solution.
Hi @Anonymous ,
I'm not sure you are using SPN or master account. In either of the case please make sure to give access to the workspace as admin.
Then you make sure to take over the dataset before udpating the credentials ?
As the error saying it's not found. May be you are missing either of the above two.
For AzureSQL i don't think you need on-premises Data gateway. But the bounddefault gateway should always need ,which is quite different from the typical on-premises data gateway.
Hi @Anonymous ,
Powershell is poor at giving the exact error especially for REST API calls. Could you please install the fiddler and try to get what is the exact error ? With the exact error only we can able to move forward for the solution.
Sorry, here the error i´m getting :
HTTP/1.1 404 Not Found
Cache-Control: no-store, must-revalidate, no-cache
Pragma: no-cache
Transfer-Encoding: chunked
Content-Type: application/json; odata.metadata=minimal
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Frame-Options: deny
X-Content-Type-Options: nosniff
RequestId: 52113063-e1ce-45ba-979d-1760cd5e88a4
OData-Version: 4.0
Access-Control-Expose-Headers: RequestId
request-redirected: true
home-cluster-uri: https://wabi-europe-north-b-redirect.analysis.windows.net/
Date: Tue, 16 Jun 2020 14:59:18 GMT
EB
{
"error":{
"code":"","message":"No HTTP resource was found that matches the request URI 'http://wabi-europe-north-b-redirect.analysis.windows.net/v1.0/myorg/gateways/7f7807d7-c24a-42e4-b578...'."
}
}
0
I´m using this code to retrieve the gateway:
i took this code from your ci cd pipeline @Jayendran
i already tried using the power bi UI to update credential and i was able to do it, but i realize that gateway.id and datasource id were diferents.
This is what i get from power bi UI.
This is using Invoke-PowerBIRestMethod
gatewayid=7f7807d7-c24a-42e4-b578-f3fb418980bb
datasourceid=846f9253-72f4-4f85-abcd-04ee75e5dce5
completly diferents.
Hi @Anonymous ,
Both gateways are totally different you should not compare it. The boundgateway is used by microsoft behind the screen in other hand the gateway url which you got is the one which you installed it.
What is your data source ? Is that a cloud or on-premises (using any on-premiese datagateway) ?
Hi @Jayendran ,
I´m using Azure Sql Server, i don´t remember having installed a gateway.
might it have installed because i'm using a vpn to connect to azure sql server?
Hi @Anonymous ,
I'm not sure you are using SPN or master account. In either of the case please make sure to give access to the workspace as admin.
Then you make sure to take over the dataset before udpating the credentials ?
As the error saying it's not found. May be you are missing either of the above two.
For AzureSQL i don't think you need on-premises Data gateway. But the bounddefault gateway should always need ,which is quite different from the typical on-premises data gateway.
Thank you @Jayendran , you were right i was missing take over dataset before update credential.
one more time thank you.
@Anonymous glad to help
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 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |