How to block consumption FROM Microsoft Excel?

[Anonymous]

I have all my .pbix consuming from a Sql Server Analysis Sevices. The setup works great!

Now; my problem is that some users found out the name of the cube, and they connect from excel... Is there a way to prevent access from excel? while of course ,letting them access using app.poewrbi.com ?

[Anonymous · Accepted solution]

I found a way here...

By using CustomData, you don't pass the UserName... So i just granted the access to a service account... so whenever someone tries to connect from excel won't be able.

[Anonymous]

I have all my Pbix consuming from a Sql Server Analysis Sevices.

The setup works great... now my problem is that some users found out the name of the cube, and they connect from excel... Is there a way to prevent access from excel? while of course ,letting them access using app.poewrbi.com ?

[lbendlin]

If you don't want them to crash your cube, don't give them access to your cube.

As far as I know it is not possible to block based on client type.