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.
We have a few Powershell scripts to handle configuration of Datasets via PBI REST API. To get gateway Id(later used to bind dataset to it) we use "GET https://api.powerbi.com/v1.0/myorg/gateways". We´ve switched to use a VNET-connected gateway, but that gateway is not returned by the API, is that by design?
If I manually execute a GET against the api that PBI UI uses(https://wabi-north-europe-redirect.analysis.windows.net/metadata/datamovement/gatewayclusters?api-ve... I get both my clusters which includes one with a VNET connected gateway and one with "normal" gateway(s). But same thing on that api if just fetching gateways(https://wabi-north-europe-redirect.analysis.windows.net/metadata/datamovement/gateways?api-version=1...) I only get the non VNET-connected.
How do I get the REST API to also return data about my VNET-connected Gateways?
We´ve now received reply on a service request that the API does not return VNet gateways.
"The engineering team have confirmed that the Get Gateways API does not return VNet gateways, only Power BI on-premise gateways.".
HI @Ehjalmar,
Ok, thanks for your sharing. They will help others who have a similar requirement.
Regards,
Xiaoxin Sheng
Hi @Ehjalmar,
How did the VNET configuration? Did any additional policy on the VNET tunnel open the corresponding ports that the gateway client required to send/receive power bi service requests?
Add Power BI URLs to allowlist - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
I don´t have insight into the exact configuration of that, but the Gateway is working and being used already, so no problem with that. The problem is that we can´t automatically connect new datasets to it via powershell scripts since we can´t get hold of the ID via the REST API like we do for non vnet connected gateways. For this one we have to do the configuration in the Power BI UI.
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 |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |