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 have a dataset which successfully connects to an azure DB via gateway when configured manually. However, when trying to configure the dataset via powershell, unable to select the gateway in 'Maps To' dropdown under the Gateway connection section of the DataSet resulting in the refresh failing with this error "It looks like scheduled refresh failed because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources.".
Note that the credentials are configured in gateway and did not have to be specified in each dataset.
If anyone have used API/Powershell script to configure the 'maps to' successfully please share your thoughts. Have used below API's to configure dataset so far.
Update DataSource - https://api.powerbi.com/v1.0/$groupsPath/datasets/$sourceDatasetId/Default.UpdateDatasources
Bind to Gateway - https://api.powerbi.com/v1.0/$groupsPath/datasets/$sourceDatasetId/BindToGateway
Refresh DataSet - https://api.powerbi.com/v1.0/$groupsPath/datasets/$sourceDatasetId/refreshes
If using Azure DevOps for deployment, in addition to using BindToGateway API, you would want to use a service account (an Azure 360 account and NOT Service Principal) that is a user on the gateway for bind and refresh to work. You need bearer token of that account to be able to accomplish the steps. This is because ServicePrincipals can not be added to powerbi gateways.
Copy below snippet to a PS file and pass in required parameters to bind gateway and refresh dataset. clientId is the Azure ServicePrincipal associated with your PowerBi workspace and pbiUserName is the sevice account that's a user on the gateway. Hope this helps!
I was able to select the Map To field with the following:
I have the same problem.
I publish our "Golden Data Set" to a workspace.
I am able to update the report Data Set Parameters "dbName" and "dbServer" using the API.
This enables the Gateway, but the "Map To" field does not select the server by default.
You have to manually select the server after the dbName and dbServer fields are updated.
I need a way to select the Data Source in the Map To dropdown using the API.
Having the same issue, anyone else able to solve this?
DevOps deploys the "Report" Dataset successfully.
DevOps updates the datasource in the "Report" Dataset successfully.
The Gateway Connection in the "Report" Dataset loses it's mapping to a 'datasource' in the On-Premise Gateway.
Hi mbutler71,
I was able to select the Map To field with the following:
Its frustrating to say the least but i havent been able to use bind to gateway api via App Id either...
Did you manage to do this?
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 |