PowerBI SSAS Cube Structure

[Anonymous]

Hello,

When uploading data/reports to PowerBI cloud it builds an SSAS cube.  You can even use the SSAS cube in Excel if you choose to locally on your pc.  I wanted to know is there way via api or other ways to download SSAS cube to customize deploy on local sql server ? 

[GilbertQ · Accepted solution]

Hi there

Currently this is not possible, it actually takes the PBIX file and takes apart the different pieces to get them into the right place.

You could script out the PBIX by connecting to it via SSMS and then scripting it out. But there are other things that would still need to be done to get it working on a local SSAS Server.

[Anonymous]

can you post link on how to "PBIX by connecting to it via SSMS"

[GilbertQ]

Hi there,

Please find this blog post on how to do this below

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/