Hello everybody,
i've a onpremise datasource (mysql), i've a power bi model with a lot of tabs (pbix) published into powerbi service
and those reports/tabs are consumed by all my onpremise users through app.powerbi.com web portal. that's running fine
and everybody is happy. thanks.
now, i would like to generate offline report (ex: pdf, ...) that will source the same model (the one i published into app.powerbi.com), so i can reuse all the measure, and all data directly to create custom report (paginated, ...)
those report should be send by email at defined schedule to users (execs level).
as far as i understand, i've only one options now:
- install SSRS and SQL Server onpremise and recreate my model into it through visual studio (will source the same datawarehouse/mysql as into the pbix model), publish it on my sql server onpremise instance to create an onpremise tabular model and then consume this tabular modal with SSRS to generate "offline" report.
someone can confirm this is the only way to go ?
there is really no option to consume the tabular model already available into app.powerbi.com into SSRS and then generate report to send by email. that will be a huge benefit.
i'm not at all a guru into srss/... , so take my question and sentence with caution and excuse concepts mismatch 😉
