Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
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.
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
So you can kind of hack it.
User | Count |
---|---|
10 | |
10 | |
3 | |
2 | |
1 |