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
EVEAdmin
Helper V
Helper V

Change data source mode: from SQL query to LOAD

Hi all,
I built a report, using records from 1 single table in a MS-SQL cloud database.
The import takes place through a simple query:

 

SELECT * FROM Table

 Is it possible to replace the query with the default LOAD option ? Clearly, without redoing the entire report.
Thank you.

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi @EVEAdmin

 

There are 3 ways:

 

In report view:double click on the bottom right corner,you will see below information

Annotation 2020-04-06 131626.pngAnnotation 2020-04-06 131800.png 

 

2.In model view: click on the table and you will see:

 

Annotation 2020-04-06 131453.png

 

3.Go to query editor,click on the "source" in the filed,and you will see:

 

Annotation 2020-04-06 132041.png

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

View solution in original post

5 REPLIES 5
v-kelly-msft
Community Support
Community Support

Hi @EVEAdmin

 

There are 3 ways:

 

In report view:double click on the bottom right corner,you will see below information

Annotation 2020-04-06 131626.pngAnnotation 2020-04-06 131800.png 

 

2.In model view: click on the table and you will see:

 

Annotation 2020-04-06 131453.png

 

3.Go to query editor,click on the "source" in the filed,and you will see:

 

Annotation 2020-04-06 132041.png

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

amitchandak
Super User
Super User

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

@amitchandak thank you.

When you connect to an MS-SQL database as datasource, PBI desktop will prompt you to select and load tables.

In my existing report, I skipped the LOAD option and imported data using a simple select query.

I'd like to revert to the LOAD option.
Hope it helps.

@EVEAdmin  If you want to change from direct query to load mode, the easiest way is to click on you query in Fields pane and in right corner you should have note for 'Storage mode', click on it and then 'Switch all tables to import'.

Capture.PNGCapture2.PNG

 

@EVEAdmin ,

Not Sure I got it. But you have option Edit Source under Data Transformation/Edit Query. Try to use that.

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.