Direct Query Changing into IMPORT Mode

[Anonymous]

Hi There,

I have a  large dataset for which i am usign Direct Query mode to get data from SQL SERVER.

As soon as i merged 2  X tables  from direct query its getting changed into Import mode .

Is there any way to prevent this and my Merge table remains in direct Query mode?

Thanks in advacne !

Regards,

Ash

[Anonymous]

Hi @Anonymous ,
Based on the problem you encountered, here are the solutions I found for you:
1. To implement table merging in SQL Server, create views in SQL Server and complete joins (JOIN operations) of tables that need to be merged directly at the database level.
2. You can try to use a composite model that allows you to keep some tables in Direct Query mode and switch the tables that need to be merged to Import mode.
In this way: large tables are still fetched from SQL Server as Direct Query, ensuring real-time and performance.
The tables that need to be merged are loaded into the local memory of Power BI through Import mode, thus avoiding complex merge operations in Direct Query mode.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[POSPOS]

@Anonymous  - Merged queries or appended queries will automatically changed to import mode as the data will be fully loaded into Power BI's memory instead of being retrieved directly from the source on every query. 
The original tables will still be in direct mode though.

[Anonymous]

@POSPOS Thank you for yiur resposne. So you nmean we cannot able to chage its property so that it will remain in Direct Query after doing Merge or Append .

Regards,

Ash

[ThomasWeppler]

When I use the buttom merge querries I can add one query on top of another one and it stays in power query.

Is that what you need? otherwise I need a bit more context.

[Anonymous]

Hi @ThomasWeppler ,

This is what i am doin however as i mentioned once i will merge as as new its chaning its property and changing the mode into "Import" however my base tabkes are in "Direct Query Mode" 

So i need if i will do Merge as New the ouput table should remain in "Direct Query mode".

Is thera nay way ?

Thanks,

Ash