RLS and Data Source in Power BI
Hello, I have started using Power BI Embedded and got good results in embedding the report. I have few questions though! 1) I see there are only two data sources (Azure SQL DataBase and Azure SQL Data Warehouse) supported right now. If I am wrong, can we connect to AWS RDS? 2) We want to filter the report visualizations and report filters based on the user logged in. With RLS, we need to set up lots of roles while generating report and maps the users to those roles. Also, there are lots of new roles and users getting created on a weekly basis and it will not be good to add rules in Power BI as and now. So, is there a better approach to this or I am missing anything? This functionality is the core to us and is there any option to send the roles/filtering options in JWT while creating the access-token. 3) What are the exporting features available except Visual-level Export (as .csv or .xlsx)? From the research we made, print and export as .ppt can be made from PowerBI service. Is there any way to export the report as .pdf or .jpeg/.png or dump the report resultset as a .csv as a whole? Thanks in advance !!!
