cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dbeavon3
Resolver I
Resolver I

Error messages from Microsoft managed vnet gateway

Has anyone else attempted to use the managed vnet gateway?  It became available as a public preview in March:
https://powerbi.microsoft.com/en-us/blog/announcing-vnet-connectivity-for-pbi-datasets-public-previe...

 

Here is more explanation: https://microsoft-bitools.blogspot.com/2021/09/virtual-network-data-gateway-for-power.html

 

 

 

The concept is great, but the implementation is not so great.  When there is a dataset refresh failure, we will see errors like so:

Unknown error in data gateway.  One or more failures have occurred.

 

... which means what?  This message is not actionable, and will not enable you to avoid the problem in the future.  They might have just said "oops something bad happened".  This error is transient and this error (or equally meaningless variations of it) will appear in about 50% of the scheduled refresh operations.  

 

 

A quick google search reveals that it is easy to troubleshoot an on-prem gateway:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot

... however nothing in this article will help you if the gateway is managed by Microsoft.

 

In the very least there should be a way to harvest the logs off the gateway, assuming the failure happened in the past 24 hours.  I've called Power BI support and even they have no access to the gateway logs.

 

Has anyone else tried using managed vnet gateways?  Have you used them long enough to encounter a failure in a dataset refresh?  How do you troubleshoot?  Do you have a direct line to someone on the product team?   (I was told they could help us, but I haven't connected with them yet -  even after a week of intermittent failures in production.) 

 

3 REPLIES 3
dbeavon3
Resolver I
Resolver I

Hi @v-xiaotang ,

 

I see that the roadmap is promising to give us more troubleshooting for the VNET gateway . 

 

https://community.powerbi.com/t5/Data-Stories-Gallery/Power-BI-Release-Plan/m-p/930557

.... "VNet data gateway troubleshooting" ... for "March 2022"

 

Do you have details about this?

 

Hopefully this allows us to see the gateway logs.  I'm not sure how it makes any sense for Microsoft to run this "gateway" service, without providing access to the logs.  The logs are critical to the on-prem version of the gateway, and it would be impossible manage the health of the gateway without those logs.

 

 

v-xiaotang
Community Support
Community Support

Hi @dbeavon3 

Sorry to hear that. 

 

Can you roughly infer under what circumstances this problem will occur? If the dataset is small, will this problem occur?

Based on my research, you can enable the Azure Virtual network diagnostic settings to get the log,

https://docs.microsoft.com/en-us/azure/azure-monitor/essentials/diagnostic-settings?tabs=CMD

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Hi v-xiaotang.  Are you sure that the azure monitor diagnostic settings will send out the Power BI Gateway logs (ie. the logging that is specific to gateway logic)?

 

... Here is how you get the equivalent logs when they live on-premises:
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot#collect-logs-from-t...

 

 

I had opened a support case and was told there may be some bug somewhere in the vnet gateway that is being fixed, but they didn't go into detail.  Nor did they give me confidence that the error messages in the "refresh history" will improve in quality.  I tend to doubt that.

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors