Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Analysis Services (Jet Reports OLAP) + Role management

Hi :)   I've installed the Enterprise Gateway and I can refresh from app.powerbi.com. I've managed the role and permissions from the JetDataManager (Olap Cubes) and when I execute PowerBI Desktop ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    v-jiascu-msft

     

    Hi Dale,

     

    Thanks again for your replies. 

     

    I tried several things, but I think my final solution is to rename the Source in PowerBI Desktop.

     

    Both sources (Desktop / Gateway) were on the same serveur / database, but one was named "Cubes Olap" and the other "Olap".

     

    It works now. Thanks again.

     

    Best regards,

    Matt

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Anonymous,

 

Hi Matthieu,

 

It seems that your server allowed the access that was unauthorized. So you should restrict it from the server side. 

If you only want to restrict the access of a Power BI dataset, you can try RLS. Reference: powerbi-admin-rls.

 

Best Regards!

Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-jiascu-msft

 

Hi Dale,

 

Thanks for your reply but :

  • I have restricted from server side because it's working if the user use the Desktop app. 
  • RLS couldn't work because of Analysis Services.

It's about the online access, I don't understand why the rights are working in local but not online, with the same user which has a valid UPN.

 

Thanks in advance

 

Best regards,

Matthieu