Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to block consumption FROM Microsoft Excel?

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 ?

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
    lbendlin
    Super User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.