powerbi virtual network gateway

[surbhi]

hi,

My azure storage account is in private endpoint so to show reports on app service of powerbi i need to create a vnet gateway for same. I have PPU license but i am trying to create gateway my license capacity is coming as greyed out. Sceenshot for reference. Please help me how to create gateway with my PPU license

[lbendlin]

"In Power BI, virtual network data gateways require a Power BI Premium capacity license (A4 or higher or any F or P)."

Use virtual network data gateway and data sources in Power BI | Microsoft Learn

PPU is not enough.

[surbhi]

 i am able to create the Vnet gateway but not getting how to connect my semantic model to it and my source is azure storage account blob with private endpoint

[v-aatheeque]

Hi @surbhi 

In Power BI Desktop, connect to Azure Blob Storage using the same credentials.
When you publish the report to the workspace, go to:

Settings > Dataset > Gateway Connection
You’ll see a list of configured gateways
Select the VNet Data Gateway that can reach your Blob Storage via private endpoint.
You may need to configure Data Source Mapping:

The data source path in Power BI Desktop (e.g., https://myblob.blob.core.windows.net/)

must exactly match the source defined under the gateway.
If needed, go to Manage Gateways > Add Data Source and map the blob source in the VNet Gateway.

Hope this helps !!

[v-aatheeque]

Hi @surbhi 

Just checking in on your progress with connecting the semantic model to the VNet Gateway. Were you able to map the Azure Blob Storage source correctly under the gateway settings and align the path used in Power BI Desktop?

Let me know if you’re still running into issues happy to help troubleshoot further if needed!

[surbhi]

yes i was able to create and connect to semantic model with gateway but my scheduled refresh is failing with below error:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: BackupJobs (A).
Cluster URI: WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net
Activity ID: 4d83b86f-514f-4235-9c3d-5972633172f8
Request ID: a3bd99f6-a0a0-196e-3ed8-e5aa7225f587
Time: 2025-08-26 07:49:54Z

not getting what exactly it is 

[v-aatheeque]

Hi @surbhi 

If you're seeing the error DM_GWPipeline_Gateway_MashupDataAccessError with code -2147467259, here are some targeted steps that may help resolve it:

• Ensure the On-Premises Data Gateway is online, updated, and not overloaded. Performance issues or outdated versions can cause mashup failures.
• If using a VNet Gateway, verify that the network route to the data source is stable and not experiencing latency or drops.
• Try refreshing the dataset manually in Power BI Service. If it works manually but fails on schedule, the issue may be related to refresh.
• Refresh the dataset in Power BI Desktop. If it succeeds locally but fails in the service, the problem likely lies with gateway configuration or service-side limitations.
• Isolate the BackupJobs (A) query and remove complex transformations such as joins, merges, or nested filters.
• Test a minimal version of the query in Power BI Desktop and publish it to see if it refreshes successfully in the service.
• Some users have resolved this by rebooting the data source server, not just the gateway. If feasible, this may help clear stale connections or memory locks.
  
  

Hope this helps !!

[surbhi]

our data source is azure blob storage with private endpoints. NO idea how to restart 0r refresh that. I refreshed the reports in desktop version and it is running fine. But whenever i tried to refresh semactic model in app service getting this mashup error

[v-aatheeque]

Hi @surbhi 

• When using Azure Blob Storage with private endpoints, refreshing the semantic model in an app service can fail due to network or authentication issues.
• Ensure the app service has proper network access to the private endpoint, verify that OAuth credentials or access keys are valid and not expired, and confirm that the data source connection in the service is correctly configured to use those credentials.
• Also, check if a gateway or managed identity is required for the app service to access the private endpoint securely.
• Restarting or refreshing typically involves re-authenticating the connection and ensuring the app service can reach the storage account through the private endpoint.

Reference : https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

[surbhi]

hi again provided the credentials i.e access key to access the Storage blob container in my cloud connection. also query n dataset is running fine in local desktop only refresh is failing with mashup error. I am not getting what else i need to do to resolve this 

[v-aatheeque]

Hi @surbhi 

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

[surbhi]

is there any workaround if we don't wanna move to premium capacity due to cost and have PPU license only

[lbendlin]

There is not. VNET gateways consume CUs, they require a Fabric enabled SKU.

[v-aatheeque]

Hi @surbhi 

Just checking in to see if you had a chance to review the response shared regarding your question on gateway usage with a PPU license.

As posted by @lbendlin earlier, VNet gateways require a Fabric-enabled SKU and do consume capacity units (CUs), so they aren't supported under PPU licensing alone.

Looking forward to hearing from you!

[surbhi]

what does F or P stands for

[v-aatheeque]

Hi @surbhi 

Just checking in to see if the documentation and guidance shared by @lbendlin earlier helped you move forward with creating a gateway for your Power BI reports using the PPU license.

Since your Azure Storage account is behind a private endpoint and you're hosting reports via App Service, please ensure the required VNet data gateway setup and networking prerequisites are in place as outlined in the shared reference.

Let us know if you’re still facing the license capacity being greyed out or need help validating your current setup happy to assist further!

[surbhi]

Not yet still looking any way to create gateway with PPU license only as premium is too expensive for us

[lbendlin]

F = Fabric

P = Premium

Microsoft Fabric - Pricing | Microsoft Azure