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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-jiascu-msft

 

Hi Dale,

 

Thanks for your reply and sorry for the delay, I was at clients this week. 

Question 1 : connection live or import

It's an import connection, but I tried with both, a report with live, a report with import, and I shared it to my test account with configured rights. 

Same in both cases, I can see everything with this account.

 

Question 2 : users "mapping"

I have a local user which has the complete email as upn : [email protected]

But.. in doubt I tried to map from PowerBI gateway online tool :

[email protected] to company\user1

And i tried too

[email protected] to [email protected]

And too 

User 1 to  [email protected] and company\user1

 

Still "nothing" because I can see everything.. 

 

Thanks in advance for ur help.

 

Best regards,

Matt

Anonymous's avatar
Anonymous
Not applicable
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 Matt,

     

    Thank you very much for sharing. I will try your solution later.

     

    Best Regards!

    Dale