using data in datawahouse in semantic model with import mode ( not direct lake) in powerbi

[ludovicLaurent]

Hi 

    i test fabric at this moment and i have created a table in the warehouse 

   i can create a powerbi report with  direct lake on this warehouse 

 
  But is it possible to create a dataset with import mode where i can import data from warehouse tables  ?  
  My aim is to give to my key user the oppurtunity  to add column or measure quickly  and also create semantic model that cross data from this warehouse   with other data coming from other source 

Thanks for your help
Best regards

[frithjof_v]

For creating import mode (not direct lake):

https://community.fabric.microsoft.com/t5/General-Discussion/fabric-data-warehouse/m-p/4018054/highl...

Please try following the steps in my comment (link) to connect to your Warehouse's SQL connection string from Power Query in Power BI desktop. Steps 1-7 should be sufficient, then select the tables you want, and click Load to load the data into your data model in Power BI desktop (or click Transform data, then Close and Apply).

[Anonymous]

Hi @ludovicLaurent,

In fact, you can directly create a new semantic model from data warehouse with table/views that you choose. Then you can share this created model to users to customize and edit based on their requirement.

Default Power BI semantic models - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng

[frithjof_v]

@Anonymous the method you describe will create a direct lake (or direct query) semantic model, isn't that right?

It is not possible to create an import mode semantic model by using the method you describe?

[Anonymous]

HI @frithjof_v 

Yes, this method create model seems still in the direct lake model.

If you want a semantic model with import mode, you can try to export these data to csv. Then you can create a new semantic model based on these files.

Regards,

Xiaoxin Sheng

[frithjof_v]

To create import model, it is not necessary to export the data as csv. That would be too complicated and not the recommended way to do it. In reality, it is a lot simpler than that.

Please see my previous answer:

For creating import mode (not direct lake):

https://community.fabric.microsoft.com/t5/General-Discussion/fabric-data-warehouse/m-p/4018054/highl...

Please try following the steps in my comment (link) to connect to your Warehouse's SQL connection string from Power Query in Power BI desktop. Steps 1-7 should be sufficient, then select the tables you want, and click Load to load the data into your data model in Power BI desktop (or click Transform data, then Close and Apply).

Actually, the simplest way is the way described by @Anonymous here: https://community.fabric.microsoft.com/t5/General-Discussion/fabric-data-warehouse/m-p/3875169/highlight/true#M7079

[Anonymous]

Hi @ludovicLaurent ,

Did frithjof_v 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng