Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kgandhi2001
Frequent Visitor

Query using Get Data using Azure

Hello Team -

 

How to write a query while using Get Data => Azure with or without Import OR Direct query mode?

 

Thanks in advance

 

-KG

1 ACCEPTED SOLUTION
kgandhi2001
Frequent Visitor

@amitchandak - I was able to get it using Databricks.Query function from Databricks.Catalog function

View solution in original post

3 REPLIES 3
kgandhi2001
Frequent Visitor

@amitchandak - I was able to get it using Databricks.Query function from Databricks.Catalog function

kgandhi2001
Frequent Visitor

Hello @amitchandak - Where to mentioned Hostname & Http link for the ODBC screenshot you mentioned?

kgandhi2001_0-1669916012221.png

 

amitchandak
Super User
Super User

@kgandhi2001 , You can write a SQL in Advance Option of connection

 

AdvanceProperty.png

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.