cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RSSapre
Frequent Visitor

paginated report does not render when connected to Azure Analysis Service

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,

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.