PowerBI dataset in import storage mode instead of Direct Query in desktop

[Rosh89]

Hi,

I have a model in desktop with multiple datasets entirely in the import storage format. I want to add another dataset which is published in powerbi service.  When I use powerbi datasets as my data source I can only get the dataset in the direct query storage format. This doesnt work for me because I want to append the existing data in the import storage and this new dataset from powerbi service. Is there any way to change the dataset from service to import storage format?

I saw many articles on how to do it but none of them work for me. I am not able to change this dataset to import format in desktop. Also tried out the Analysis services option as a datasource which gave an 'en-DE' culture error.

Does anyone have any recommendations?

Regards

Rosh

[Anonymous · Accepted solution]

Hi  @Rosh89 ,

As far as I know, if your dataset is already connected to the data source through import mode, and then you want to connect the dataset, it will automatically convert from Live connection to DQ mode, but DQ mode is not a standard DQ mode, but a live connection mode that adds the function of connecting to other data sources to establish relationships between tables. It does not have the option of converting to import mode.

For details, you can check this document:

Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn

Best Regards,

Liu Yang

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