Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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:
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:
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'.
Not Sure I got it. But you have option Edit Source under Data Transformation/Edit Query. Try to use that.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |