change from import to direct query

[Giada90]

Hi,

I had a report made with tables in import, I need to have all in direct query.

I tried to get data of the same table in direct query and I change the m language coping the m of direct query and pasting it in the table in import mode but it's still in import.

Does it exist a workaround to return in direct query without making the report again?

Thanks

[Tahreem24]

@Giada90 , Kindly refer the below blog for your scenario. Workaround is availble on mid of this blog.

https://spgeeks.devoworx.com/switch-import-to-directquery-mode-powerbi/

[DataInsights]

@Giada90,

Power BI doesn't allow changing from Import to DirectQuery. The Storage mode setting is in Model view:

You'll have to recreate each table and its relationships.

[Giada90]

@DataInsights thanks, I already know it, but I'm asking if there is a workaround to do this

[DataInsights]

@Giada90,

Unfortunately, I'm not aware of a workaround. I looked at the blog from @Tahreem24 but wasn't able to use either method. Method 1 is no longer relevant because the storage mode has moved to Model view. Method 2 (what I stated) consists of deleting and recreating each table and its relationships.