Change data source mode: from SQL query to LOAD

[EVEAdmin]

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.

[v-kelly-msft · Accepted solution]

Hi @EVEAdmin ，

There are 3 ways:

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

 

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

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

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

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

Appreciate your Kudos.

[EVEAdmin]

@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.

[astojanac]

@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'.

[amitchandak]

@EVEAdmin ,

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