Forum Discussion

flopi's avatar
flopi
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Customdata() - support in the datasource for on-premise Power BI Reports

  Hi,   could you please comment, if the customdata()-function is going to be supported for Power BI Reports on the Power BI Reportserver ? Both paginated and mobile Reports are working great and...
Power BI Report Server
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi flopi,

     

    From this article, we can know that 

    You cannot define roles within Power BI Desktop for Analysis Services live connections. You will need to do that within the Analysis Services model.

    Also, per my understanding, the RLS only works when publishing Power BI reports to service, as we need to add members to roles on service site.

     

    You could submit this idea at this page: https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Regards,
    Yuliana Gu

flopi's avatar
flopi
Icon for Advocate I rankAdvocate I
9 years ago

andreigarzon: Are you able to change the credentials to another user in the August Release ?

andreigarzon's avatar
andreigarzon
New Member
9 years ago

I am using PBIRS with Forms Authentication. In this scenario PBIRS can connect to SSAS with a predefined user, but in the connection string you can add CustomData={{USERID}}  to get the Forms Authenticated User and pass this user to SSAS to achieve RLS.