Forum Discussion

rhartop's avatar
rhartop
Frequent Visitor
1 year ago
Solved

Databricks VNet DM_GWPipeline_Gateway_MashupDataAccessError

We are getting the following error when trying to refresh data from databricks via a VNet gateway. We have checked everything we can think of in terms of what might be causing the error though so far...
Need Help
  • Ni_BI_Żak's avatar
    Ni_BI_Żak
    1 year ago

    Walkaround is possible by native queries

    Value.NativeQuery(Databricks.Catalogs(
    "adb-xxxxxxxxx.azuredatabricks.net",
    "/sql/xx/xx/xx",
    [Catalog = "xxx", Database = null, EnableAutomaticProxyDiscovery = null]
    ){[Name = "xxx", Kind = "Database"]}[Data],

    "select * from Sample",
    null,
    [EnableFolding = true])

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi  rhartop 
Thank you for reaching out microsoft fabric community forum.
Ensure that your VNet Gateway is properly configured in Databricks and is accessible by Power BI. Ensure the on-premises data gateway is running the latest version.
Double-check the data source settings in Power BI, especially if you're using custom queries or transformations in the mashup.
If the issue still persists, please consider raising a support ticket. You can create a Microsoft support ticket using the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket


If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

Thank you.