Skip to main content

Power BI

Needs Votes

Enforce live query against SSAS sources

Vote (148) Share
Marc Power BI User's profile image

Marc Power BI User on 28 Jan 2016 16:54:43

For Enterprise data sources such as SSAS models, it would be desirable to have a centralized way to enforce Power BI Desktop users to use live query mode and prohibit data import. This will ensure that none of that data will be pushed to the Power BI cloud service. Should be possible to define this on a per cube/model or SSAS server basis.

Comments (11)
Marc Power BI User's profile image Profile Picture

c26729e5 9e02-4ffa-b850-3ae9a90f7c31 on 05 Jul 2020 22:21:44

RE: Enforce live query against SSAS sources

I agree, it looks like there are on-premises connectivity options but endusers can still upload their own data directly. Could this be addressed with an administrator level control to require only live query sources?

Marc Power BI User's profile image Profile Picture

92455d6d 627c-4c2c-9fcf-ba128dd25ffb on 05 Jul 2020 22:16:32

RE: Enforce live query against SSAS sources

Would enable us to use PowerBI easier

Marc Power BI User's profile image Profile Picture

55e90c01 fb03-45e7-a78a-5df3a9bf4fae on 05 Jul 2020 22:14:55

RE: Enforce live query against SSAS sources

Tesd

Marc Power BI User's profile image Profile Picture

48efe1aa 0468-4cc7-8a5e-e9d1e13868a2 on 05 Jul 2020 22:14:55

RE: Enforce live query against SSAS sources

Absolutely true, a request we've heard a lot, this would take away a lot of concerns for using PBI

Marc Power BI User's profile image Profile Picture

55e90c01 fb03-45e7-a78a-5df3a9bf4fae on 05 Jul 2020 22:14:54

RE: Enforce live query against SSAS sources

Test

Marc Power BI User's profile image Profile Picture

aaaf623f 2eff-497a-8321-5016ec02e56a on 05 Jul 2020 22:14:50

RE: Enforce live query against SSAS sources

Very good and important Feature. I hope this will be implemented in the next few weeks.

Marc Power BI User's profile image Profile Picture

ab79d670 5547-4508-a43f-838056f2b9d7 on 05 Jul 2020 22:14:50

RE: Enforce live query against SSAS sources

I had this very discussion yesterday with a banking customer of ours. Because I was not able to show them that there's robust, active restriction (despite the admin tenant sign-up blocking) it was a non-starter.

Marc Power BI User's profile image Profile Picture

0f23de7d 4aec-4af4-ab67-157c4926e289 on 05 Jul 2020 22:14:50

RE: Enforce live query against SSAS sources

Would drive adoption of cloud and PBI

Marc Power BI User's profile image Profile Picture

26f45ec3 54b6-45e9-8240-770e2294140f on 05 Jul 2020 22:14:50

RE: Enforce live query against SSAS sources

I absolutely agree, that would be a very important feature to help adopting dashboarding on the cloud with on premise data sources.

Marc Power BI User's profile image Profile Picture

f5a5f1ec 38f9-4b44-9372-07e5abfff8e7 on 05 Jul 2020 22:14:50

RE: Enforce live query against SSAS sources

I also agree. Very important to implement robust data security models.