Databricks VNet DM_GWPipeline_Gateway_MashupDataAccessError

I had the same/similar issue and brought up with Microsoft support. The issue is the driver on VNET gateway needs a fix, and Microsoft is waiting on databricks for the updated driver. No timeline available 

MS Support says that Databricks has planned to fix this issue "around April", and they suggest disabling cloud fetch as a temporary workaround (as mentioned by Deku).

However, I tested with the workaround proposed by Ni_BI_Żak, using Value.NativeQuery(Databricks.Catalogs()) as a replacement for Databricks.Query(), and that resolved the issue for me. So the culprit seems to be Databricks.Query().

This doesn't work:

let
    Source = Databricks.Query(
        "adb-xxxxxxxxxx.x.azuredatabricks.net",
        "/sql/1.0/warehouses/xxxxxxxxx"
    ),
    Query = Source("SELECT * FROM my_catalog.my_database.my_table") 
in
    Query

Use this instead:

let
    Source = Databricks.Catalogs(
        "adb-xxxxxxxxxx.x.azuredatabricks.net",
        "/sql/1.0/warehouses/xxxxxxxxx"
    ){[Name="my_catalog", Kind="Database"]}[Data],
    Query = Value.NativeQuery(Source, "SELECT * FROM my_database.my_table") 
in
    Query

Same issue here. Thanks Deku for the update on root cause!

Feels like i'm having similar issues with a paginated report that is trying to load data from databricks within powerquery. No gateway involved in this setup but it's the same error message.

Expression.Error: The provided options are not valid.

Same query runs fine within PowerBi desktop.

Keeping an eye on this to see if you get a solution.

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.

Hi bergmaal 
That's great to hear that you found a workaround 😊.

Hi rhartop 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.