Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi, I was creating a paginated report (a simple one for testing) and connected to the PBI dataset. I used the wizard each time
Each time I attempt to run it, it fails, unable to create the report
I then recreated the report using the SQL Server database that the PBI report is based on, and the Paginated report ran perfectly and fast.
I was wondering some reasons why a report wouldn't run using a PBI dataset, but run directly against the SQL database quickly. The powerBI report is working well, but a paginated report isn't.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |