Skip to main content

Power BI

Needs Votes

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

Vote (368) 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 (31)
Jay Eckles's profile image Profile Picture

a3998d99 1562-47db-8aa2-3888bc34ce78 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

4c830e52 d8f6-4216-8c0c-9ead551d437a 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

9420e320 5c31-410b-80fe-a532017f865e 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

fb435a20 898e-4cca-b193-bd79af29f95a 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

3e632b5a 6a38-49b7-a377-ae1afb8400b2 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

bae2b822 5bde-463d-ab66-503e05bec0d1 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

31ba9f99 9388-481d-a46d-2cb086fdfa43 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

3e632b5a 6a38-49b7-a377-ae1afb8400b2 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

0937c763 1f73-48ff-894f-72547b9abde6 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

2c0c3ea5 9077-4d18-bb50-af85bde86619 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!!!!