How to change from local direct query mode to import using the published semantic model

[JulieKucher]

Hi guys, 

I have a task where dashboard is currently set to local direct query mode, but it needs to be configured as an import using the published semantic model in the dataset workspace. Is it real that we can't switch between these modes? DO I have to create a new dashboard with the correct storage mode, transfer the dashboard pages and on top of it to recreate the filters? IS there any magic way to do it without having to recreating another dashboard? @GuyInACube @PragmaticMan @Bibi 

Thank you 

[JulieKucher]

But again another question comes up. Is it possible to get data from Power BI published dataset in import mode?When I get data from Power BI published dataset into totally blank report, I see that data source type is SSAS database. So now I am confused, do I have to bring the data from SSAS? I understood the task as using the published dataset and as far as there in dataset was used stored procedure, it  should be connected to SQL Server. What do you think about it?

[Jai-Rathinavel · Accepted solution]

@JulieKucher 

1. If your requirement is to getting data used in SSAS model to Power BI and retiring the SSAS model you can consider pulling the data directly from SQL Server inside Power BI but check for ETL transformations done on SSAS model and apply the same transformations in your Power BI model's power query so that you are not missing out on logics or additional columns. 
2. If your requirement is to use the SSAS model as your only source then you can consider Direct Query but reports built on direct query will be slow. To speed up the report you can switch to import mode but if the data in SSAS model is subsequently higher you will be having high refresh times.

[JulieKucher]

thank you for your time and answer

[Jai-Rathinavel]

@JulieKucher , If my post has resolved your issue, please accept it as solution. Thanks 🙂

[Jai-Rathinavel]

Hi @JulieKucher ,

1. Download the Model PBIX from Service.

2. Open the file in Power BI Desktop

3. Go to modelling view and select the table where you want to change the Mode

4. Under Advanced -> Storage Mode on the right side you can Switch between Import, Dual or Direct Query

5. Republish the model after making changes

Did I answer your question ? If yes, please mark this post as a solution.

Thanks,

Jai