Forum Discussion

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
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])

AlasdairL

New Member

1 year ago

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.

Details

Reason = Expression.Error

Detail = {"DefaultTypeParameters"}

Same query runs fine within PowerBi desktop.

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

Ni_BI_Żak
Frequent Visitor
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])