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

Power BI User 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

Power BI User 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

Onboarding User on 05 Jul 2020 22:14:55

RE: Enforce live query against SSAS sources

Tesd

Marc Power BI User's profile image Profile Picture

Daniel Waber 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

Onboarding User on 05 Jul 2020 22:14:54

RE: Enforce live query against SSAS sources

Test

Marc Power BI User's profile image Profile Picture

Kristian Bubalo 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

Jason Dunbar 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

Power BI User 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

Power BI User 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

Power BI User 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.