topic Re: using data in datawahouse in semantic model with import mode ( not direct lake) in powerbi in Data Warehouse

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

ludovicLaurent — Wed, 10 Jul 2024 07:03:37 GMT

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

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

frithjof_v — Thu, 11 Jul 2024 07:46:56 GMT

For creating import mode (not direct lake):

https://community.fabric.microsoft.com/t5/General-Discussion/fabric-data-warehouse/m-p/4018054/highlight/true#M8611

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).

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

Anonymous — Thu, 11 Jul 2024 01:42:52 GMT

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

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

frithjof_v — Thu, 11 Jul 2024 07:46:37 GMT

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?

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

Anonymous — Tue, 30 Jul 2024 08:44:47 GMT

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

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

frithjof_v — Tue, 30 Jul 2024 13:43:01 GMT

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...

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

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

Anonymous — Fri, 23 Aug 2024 08:03:41 GMT

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