Power BI Model Transfer

[Anonymous]

Yo Power BI experts. Question for you. These days allot of users are picking up and creating modelling data in Power BI.
After awhile they create something that they want to repeate with all those key measures, and data points that they have.
So now the organization now knows the PowerBI Model they want to use for business. It's time to transfer and offload that workload to SQL Server.

So for a SQL Server person, we want to go ahead and turn on SSAS.

Which mode is best for our PowerBI people? - Multidimensional, Tabular Mode, PowerPivot mode ?

Are there options to export power BI model convert that into a SSAS cube for them to use since all the data is on the SQL Server?
Or is this a recreate the cube from strach? That would be a bummer!

Personally it would be just nice to start save as to SSAS the Power BI desktop models to the SQL Server and publish to it. Once all the "figuring out" parts have been done done by the Report designers.

In my senerio we use Power BI on premise using the SSRS, but I don't think that matters for this use case.

Look forward to any answer people have!
Thanks.

[v-lili6-msft]

hi  @Anonymous 

I would suggest you do modeling in SSAS, then you could also use power bi to live connect to it.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-ssas-multidimensional

Regards,

Lin

[Anonymous]

Which SSAS mode would you recommend that works best for Power BI models?

We will only be using SSAS for Power BI model as our hub Datamodels.

Multidimensional and data mining

Tabular mode

PowerPivot Mode

If you know of any tricks to convert Power BI models to SSAS or tools that would be great too, it would save me allot of time from recreation, since I'm trying to offload Modelling to our Power BI Powerusers. Unfortunately our company will be running Power BI on premises with Report Server.

[v-lili6-msft · Accepted solution]

Hello @ninken

Sorry for late response, to convert Power BI models to SSAS, you can check out this blog:

https://www.biinsight.com/import-power-bi-desktop-model-ssas-tabular-2016__trashed/

Best regards

Lin

[DataInsights]

@Anonymous, 

As an alternative to SSAS, you can create a master report with the complete data model, publish it to powerbi.com, and use the dataset as a source for other reports. This allows measures to be defined in one place and shared throughout the organization.