Skip to main content
Microsoft Idea

Power BI

Needs Votes

Support switching SSAS connect model from "Connect Live" to "Import"

Vote (556) Share
Jay Eckles's profile image

Jay Eckles on 09 Mar 2017 04:01:59

Once a report is created with an SSAS source using Connect Live, the mode cannot currently be switched to Import. This is frustrating if we have a report that we decide we want to publish to the web.

Comments (51)
Jay Eckles's profile image Profile Picture

Power BI User on 05 Jul 2020 23:53:05

RE: Support switching SSAS connect model from "Connect Live" to "Import"

This needs more votes for sure. Seems like a huge oversight to not have this.

Jay Eckles's profile image Profile Picture

David Erickson on 05 Jul 2020 23:50:17

RE: Support switching SSAS connect model from "Connect Live" to "Import"

I have created a very complex, universal report for our business, that has lots of pages, visuals, buttons, bookmarks, etc. It has been iterated over several months, but we realized recently that we should have done Import Mode for better performance and not Live Query. Since there is no easy way to convert live query to import mode, it means that we might have to pretty much start over if we want to go on import mode for better performance. Even with the copying/pasting feature, I can still see this project taking 2 weeks... this is a must, and I wish it had more than 253 votes...

Jay Eckles's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:00

RE: Support switching SSAS connect model from "Connect Live" to "Import"

Why is this not as standard???

Jay Eckles's profile image Profile Picture

Naveen Raj on 05 Jul 2020 23:43:10

RE: Support switching SSAS connect model from "Connect Live" to "Import"

An important feature that is REQUIRED

Jay Eckles's profile image Profile Picture

Anusha on 05 Jul 2020 23:39:10

RE: Support switching SSAS connect model from "Connect Live" to "Import"

This is very useful and should be done sooner. I created a report in live mode and now I want to do grouping/binning which is not possible in live report. So need to switch to import mode so get it done. This itself is not possible and makes me stuck as I need to go to DW to fix the issue. Bit frustrating as I don't have power to bin the data in live mode which is such an important feature itself.

Jay Eckles's profile image Profile Picture

Edge del Rosario on 05 Jul 2020 23:38:19

RE: Support switching SSAS connect model from "Connect Live" to "Import"

This is going to be very useful (since I go back and forth across sources) :)

Jay Eckles's profile image Profile Picture

Mahdi Shabani on 05 Jul 2020 23:37:52

RE: Support switching SSAS connect model from "Connect Live" to "Import"

I really need it too.

Jay Eckles's profile image Profile Picture

Anusha on 05 Jul 2020 23:34:57

RE: Support switching SSAS connect model from "Connect Live" to "Import"

I agree. I need to change my current model data connection to import as I am unable to use certain functionalities in live mode (which is a big power bi disadvantage). But I don't want to start building my reports again which I have already developed. PBI should be feasible enough in switching modes.

Jay Eckles's profile image Profile Picture

WAK on 05 Jul 2020 23:33:18

RE: Support switching SSAS connect model from "Connect Live" to "Import"

This feature is very useful and helpful.

Jay Eckles's profile image Profile Picture

Daniel on 05 Jul 2020 23:31:29

RE: Support switching SSAS connect model from "Connect Live" to "Import"

This is would save so much time!!! Please add this in!!!! Both directions would be good!!! please!!!!