The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I built a paginated report using PBI data set. However, it does not render the report. Hence, I built a tabular model using AAS.
I rebuilt the report on AAS model. While in design mode, I could run the query by opening the dataset and it renders the data.
In report builder as well as on PBIRS, when I run the report, I am able to select the parameters. This means it connects to my AAS model. However, when I click "view Reports" button from Power BI report builder, it just does not render. It gives me out of memory error. Not sure if I am missing any step. Any help is appreciated.
Exception of type 'System.OutOfMemoryException' was thrown.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.
@RSSapre - Very little information to go on. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Hi Greg,
Thank you for the response. Let me know what information is needed and hopefully, I can provide it.
Here are the steps I took.
I am not sure if I need to down load Report builder from PBIRS and use it. However, I feel that Power BI Report Builder should work.
Do I need to enable Kerberos delegation?
Thanks,
Raj
Update -
It appears that the number of fields is causing the problem. I have 31 fields and not a large dataset retrieval based on the parameters.
I can run the exact same report when use data source as Power BI Service. Unfortunately it is not supported on Power BI Report Server, hence, has to go through AAS route.