Hello everyone,
We are moving about 100 SSRS reports over to Power BI. Standard reports are simple enough, but a few complex ones are giving us trouble.
Subreports: A few key financial reports use a master report with 3-4 subreports inside it. Power BI paginated reports (RDL), subreports load noticeably slower. Is it better to keep subreports or rebuild then into a single report with multiple tabes/datasets?
Multi value params wth stored procs: our SQL stored procedures take multi select parameter values as comma-separated text. What is the cleanest way to pass multi-value slicers directly into stored proc or SQL queries in Power BI ?
Looking for any practical tips or lessons learned from folks who has done this.
Thanks!