Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

ctjbspowerb27

Native Query for Azure Databricks/Databricks - not working in the powerbi workspace/service

Submitted by on ‎03-05-2023 03:53 PM

With recent release, Azure Databricks/Databricks connector now supports Native Query. This was an exciting news and works fine in PowerBI desktop.

 

However this is not the case when you publish the report to PowerBI Workspace/service and try refreshing there. I get an error saying Native queries aren't supported by this value (see below image)

 

I'm guessing for some reason, native query is supported on desktop but not on powerbi gateway for workspace/service and does not understand the below in Advanced Editor. Looked everywhere online and there weren't much suggestion to solve this issue.

 

 Very happy to use databrick connector with native query but it's only 50% good if i cant get the report to refresh automatically with scheduled time. Please help! (or at least an ETA on when this update will be done)

 

ctjbspowerb27_1-1678059870829.png

ctjbspowerb27_2-1678059920489.png

 

 

Status: Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎03-05-2023 05:41 PM

Hi @ctjbspowerb27 ,

 

When you publish a report to the Power BI service, you connect to Azure Databricks using a personal access token or an Azure Active Directory token. In the Power BI service, you can also enable single sign on (SSO) so that users can access reports built using DirectQuery storage mode by passing their Azure Active Directory credentials to Azure Databricks.

  1. Publish your Power BI report from Power BI Desktop to the Power BI service.

  2. Enable single sign on (SSO) access to the report and underlying data source.

    1. Go to the underlying Azure Databricks dataset for the report in the Power BI service, expand Data source credentials, and click Edit credentials.
    2. On the configuration dialog, select Report viewers can only access this data source with their own Power BI identities using Direct Query and click Sign in.

 

For more you may refer ：

Connect to Power BI - Azure Databricks | Microsoft Learn

 

Best regards.
Community Support Team_ Caitlyn

ctjbspowerb27
Regular Visitor
‎03-05-2023 06:29 PM

@Anonymous 
Thanks for the prompt response, 

 

What would be the solution for cases like Import of data into pbix -> published -> Auto refresh in Powerbi workspace/service showing the error of "Native Queries are not supported..."  ? 

Idea Statuses