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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lobylow
Regular Visitor

Switching from Direct Query to Import for Parametirized Data Source

I am experiencing an issue when having to switch from Direct Query to Import mode on an existing data source. The Query is using parametarized Server and Databse Name, which were set-up in the Advanced Query editor.

 

When wanting to edit the Data Source from the first query step, in order to switch from Direct Query to Import, I get an alert message of the ServerName and DatabaseName not being filled in. Thus I can not save the changes to Import, and being stuck with Direct Query.

 

Is there a way to switch from direct query to import, not from the Query Step setting itself?

1 REPLY 1
lbendlin
Super User
Super User

Are these parameters bound to any columns in your data model?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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