intelequia / dnn.powerbiembedded

A set of modules to embed Power BI workspaces in a DNN Platform portal through Power BI Embedded
MIT License
11 stars 2 forks source link

Issue with RLS report. Report fails to load. #30

Open albertverges opened 10 months ago

albertverges commented 10 months ago

Hi,

You have done a great job with this module.

I have been testing your module and I have found an issue with RLS reports. Reports without RLS worked fine, but setting a report with RLS allways fails.

After inspecting the module source code and I have seen that the module sends all current user DNN roles as a PowerBI Roles, so powerBi can receive unknown roles by powerbi, And I suspect that powerbi does'nt like to receive unknown roles.

I have made a little change on source code to allow choose whitch roles are sent to powerbi. Sending roles that exists on the report, the module works fine with RLS reports.

¿ Is there any reason to send all user roles to powerBI ? I believe that is more usefull to choose whitch roles send to powerbi to ensure that this roles exists on powerbi side.