Forum Discussion
Change Direct Query to Import query and Refresh
Hello
We are using the Power BI Templates of Microsoft for Stats.
Theser Reports are Direct Queries
Can they be changed to import query and also automatically refreshed.
If yes how can I refresh them automatically
Regards
Heinrich
Hi Heinrich
Import mode refresh automatically happens only on Power BI service. but if you want your Power Bi desktop report should automatically refresh you have to manaullay refresh it by clicking on refresh button.
Power BI desktop report wont refresh automatically everytime you want lastest data you have to hit refresh button. But once you setup the gateway and schedule a refresh on Power bi service it will refresh on daily weekly basis.
I hope I answered your question!
7 Replies
Hi Heinrich
Import mode refresh automatically happens only on Power BI service. but if you want your Power Bi desktop report should automatically refresh you have to manaullay refresh it by clicking on refresh button.
Power BI desktop report wont refresh automatically everytime you want lastest data you have to hit refresh button. But once you setup the gateway and schedule a refresh on Power bi service it will refresh on daily weekly basis.
I hope I answered your question!
Hi Heinrich
If you're connected by Direct Query, you'll see the message "DirectQuery: Enabled (Click to Change)" in the status bar at the bottom right hand screen on Power BI Desktop:
Click on the message, then you should be able to change Direct Query to Import Model.
I hope I answered your question!
Hi Heinrich
Refer all these blog for reference
https://community.fabric.microsoft.com/t5/Desktop/Direct-query-to-Import-mode/m-p/2859697#M985426
I hope this might help you!
I hope I answered your question!
Hello All
Thank you very much for your support
Heinrich
