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.
Presently I created reports based on my SQL DB with "Direct Query" option, Now i want to switch same report into "Import" option, so is any provision for that to switch this thing immediately
Solved! Go to Solution.
@amitpatil35 Hi, on the status bar bottom right corner, there's a text that reads "Direct Query: On (Click Here To Change)", if you click that and pick Import, your model should start importing.
Note that this is currently a one way trip. i.e., an Import Model cannot be converted back to DirectQuery.
How to do this with SQL Server database?
Illchay
Thanks, just the answer I was looking for!
I found this way, it seemed easy:
You go to "edit queries", then you select any table and then you click on "source" in the applied steps window.
A pop up will show up asking you if you want to switch all table to import mode.
This does not work anymore.
Hello @Anonymous
I have tested it and it is still working.
Here's a picture for more details
There's alos another method described in this article
https://epmstrategy.com/power-bi-changing-storage-modes-ie-changing-from-direct-query-to-import/
Good luck
6/19/2021. How do I switch from DQ to Import? clicking on SOurce does Nothing.
hi,
I have found a way to force the switch from DirectQuery to Import.
1- Create a csv file
2- Click on Get Data, choose csv file option
3- Click on Load
4- a message would be displayed saying that all queries must be switched to import Mode
5- click on Switch
6- Refresg the model
Then delete the newly created query from a csv file.
Voila!
@amitpatil35 Hi, on the status bar bottom right corner, there's a text that reads "Direct Query: On (Click Here To Change)", if you click that and pick Import, your model should start importing.
Note that this is currently a one way trip. i.e., an Import Model cannot be converted back to DirectQuery.
Can't see the Status Bar.
This should be in the bottom right by the zoom slider, and say Storage Mode. It may be set to mixed if you already have a Imported dataset in your file
Hi there
I have the same requirements but I am on April release and I dont seem to see the option to change to Import mode.
Please could you help?
Many thanks 🙂
Same here. This no longer works 😞
Same here. I need to switch from live to import.
Tested and validated, workd as described from moving from Direct Query to Import. Does not appear to support changing from Import to DQ.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |