cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShubhamK
Helper V
Helper V

Changing SSAS cube connection to SQL Server

Hi Team,

 

I have SSAS cube connection and wants to change it to SQL server connection. I see that Transform/Get data options are disabled. I don't want to create a new report , wants to make this change in the existing report.

 

Thanks,

Shubham

4 REPLIES 4
parry2k
Super User
Super User

@ShubhamK it is not straight forward as  you will be changing the source from direct query to import. try this technique, make a backup of your report before testing it out.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Thanks for the reply. But that post is about changing conenction from SQL Server to SSAS. But i want to do reverse, there is a report alreaady with existing SSAS conenction and i cant open query editor to change it. 

@ShubhamK I know but the solution is going to be the same (i think) or change your report to import by clicking the bottom right corner and then you will be able to change to any data source.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@parry2k Somehow i am not able to click on this. Seems like it is not clickable.  Could you please check once ?

ShubhamK_0-1595014131775.png

 

Thanks,

Shubham

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors