Power Bi Embedded with RLS Filter

marcio_fornari · ‎01-07-2020

Hello everyone,

I create one Funcion called cod_user to filter the report by cod_user:

I get the user logged in my php app:

$cod_user = Auth::user()->cod_user;

How do i do to filter this RLS in Javascript API?

var models = window['powerbi-client'].models;

var permissions = models.Permissions.All;

var config = {
       type: 'report',
       tokenType: tokenTypeReport == '1' ? models.TokenType.Aad : models.TokenType.Embed,
       accessToken: accessToken,
       embedUrl: EmbedUrlReport,
       id: EmbedReportId,
       permissions: permissions,
          settings: {
             filterPaneEnabled: false,
             navContentPaneEnabled: true
           }
};

 var report = powerbi.embed(embedContainer, config);