Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello,
I was asked to create a handful of reports in Power BI to automate a process of delivering reports on a weekly basis. The issue is the end user requires these reports in an Excel or CSV format and some are too large to export via Power BI. In my former life, I used SSRS for these types of situations, however, my current workplace does not have SSRS implemented. Does Power BI have anything similar to SSRS built in, whereas I could create a custom SQL query and schedule it to run and email the output? Thanks!
If SSRS (paginated reports) are importan and Premium to expensive you can consider Premium Per User. This cost $20 pr license, but have support og paginated reports.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-per-user-faq
Paginated reports are nothing but SSRS reports and is only available in premium workspace. Is yours is premium workspace ? (workspace will have diamond icon)
Unfortunately not. Our organization has not fully committed to Power BI so we are working on Pro licenses at the moment - not on premium. Thanks for the info!
Power BI allows paginate reports in the cloud.
Paginated reports in the Power BI service - Power BI | Microsoft Docs