Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Deploy PBIX to SSAS

I have a Power BI model built using Power BI Desktop tool connecting to Power BI Service using Live connect method.

Is it there any way I can push this to SSAS?

2 REPLIES 2
Anonymous
Not applicable

Are you looking to push the model itself to SSAS? If that is the case, then no, that will not work. There was a time when you could use a tool it import it into a SSAS Tabular model, but it looks like that was removed.

 

https://www.biinsight.com/import-power-bi-desktop-model-to-ssas-tabular-2017-using-azure-analysis-se...

 

I could be wrong, but if you want that business logic to exist in SSAS you will most likely need to construct it there manually and then simply consume it from Power BI, so the reverse of what you are doing currently.

 

If you are talking about something other than this, we will need to have more detail to be helpful.

Anonymous
Not applicable

I genuinely have no idea if what I'm about to propose will work. I have no way of testing this at the moment as my dev server is offline.

 

When you open a PBIX on your local machine it spins up a "captive" SSAS instance. If you use DAX studio you can in fact connect to this captive instance and it will show you the port number. See this post for different ways to find the captive "port"

 

https://www.biinsight.com/four-different-ways-to-find-your-power-bi-desktop-local-port-number/

 

You can then use SSMS on your local machine to connect to this instance and you can script out the SSAS Model. You should get a big JSON file. This script won't execute without some modification, there are bits of the JSON not supported by SQL2016/17/19 SSAS.

 

There's some detail about this on this post

 

https://community.powerbi.com/t5/Report-Server/Accessing-Power-BI-Report-Server-data-from-other-appl...

 

So you can kind of hack it.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.