paginated report does not render when connected to Azure Analysis Service

RSSapre — Fri, 04 Sep 2020 22:51:10 GMT

Hello Team,

I have a strange problem and trying to figure out a solution.

I am building a solution where data gets consolidated on Azure SQL DB. I had a data model built in Power BI by improting data and developed reports. The PBIX was published on Power BI service and everything is running fine.

Then came a request for the paginated report. Since we have Power BI Report Server, I thought of laveraging it. However, connecting to dataset in Power BI service is not supported on PBIRS. Hence, I built a tabular model using Azure Analysis Server. Then I developed my paginated report.

I can connect to AAS, build dataset, define parameters using both Report Builder (downloaded from PBIRS) and Power BI Report Builder. When I run the report, it cannot render data if my dataset has fields from multiple tables. If I have fields from single table, it renders the report. It gives "out of memory" exception. I tried to scale up my AAS, however, same error.

Wondering what could be the problem and resolution. Any help is appreciated.

Thank you,

Re: paginated report does not render when connected to Azure Analysis Service

Greg_Deckler — Sat, 05 Sep 2020 01:27:39 GMT

RSSapre 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".

topic paginated report does not render when connected to Azure Analysis Service in Report Server

paginated report does not render when connected to Azure Analysis Service

Re: paginated report does not render when connected to Azure Analysis Service