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,

 

I thought it was a Service from a party outside of Microsoft. Let's talk about some simple explanations first.

>>>The email address, that you sign into Power BI with, is what we will pass to Analysis Services as the effective user. 

1. If your SSAS server is in a domain company.local, you could grant access to [email protected], [email protected].

2. If you log in Power BI Service with the same address like [email protected], you don't need to map users.

3. If you log in PBI Service with user1@company.com, you need to map users.  And you need to map a user to a proper user in order to get the proper access.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Question: 1. Can you make it more clear what the type of connection is? Live or import?

2. How did you map the users?

 

Reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-ssas/#map-user-names

 

Best Regards!

Dale

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