cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

PowerBI SSAS Cube Structure

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 ? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: PowerBI SSAS Cube Structure

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: PowerBI SSAS Cube Structure

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

New Member

Re: PowerBI SSAS Cube Structure

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

Highlighted
Super User IV
Super User IV

Re: PowerBI SSAS Cube Structure

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/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors