Change Direct Query to Import query and Refresh

[Heinrich]

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

[Heinrich]

Hello All
Thank you very much for your support
Heinrich

[Heinrich]

Hello @Uzi2019 
Hope you are doing well.
Yes you are right.
So in Power BI Service it would be possible, right?
BTW. Do you know if it is possible to change CQD / QER from direct query to import query?
Thank you very much
Heinrich

[Uzi2019]

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!

[Uzi2019]

Hi @Heinrich 

Refer all these blog for reference

https://community.fabric.microsoft.com/t5/Desktop/How-to-change-one-table-direct-query-to-import/m-p...

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!

[Heinrich]

Hello

Thank you for your answer.

This is what I see:

But then I get this error

What can it be?

Regards
Heinrich

[Uzi2019]

Hi @Heinrich 

Refer  below blog:

https://community.fabric.microsoft.com/t5/Desktop/OLE-DB-or-ODBC-error-Type-mismatch-Exception-from-...

https://community.fabric.microsoft.com/t5/Desktop/OLE-DB-or-ODBC-Error-Exception-of-Type/m-p/635036#...

https://community.fabric.microsoft.com/t5/Power-Query/Exception-of-type-Microsoft-DataProxy-Exceptio...

I hope this might hep you!

[Uzi2019 · Accepted solution]

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!