Forum Discussion

LavanyaI's avatar
LavanyaI
New Member
3 years ago

Paginated Report not rendering in Power BI Service

We have a paginated report published to Power BI Premium Service whose datasource resides on Azure sql db and since a few days has stopped working. The underlying dataset is a view which is used by ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Hi LavanyaI 

 

What happens if you change the query to select top 1, just to check if it then works to try and troubleshoot?

 

 

LavanyaI's avatar
LavanyaI
New Member
3 years ago

Hi Gilbert,

Yes,when I change the query to Top 1* it does work and render the report, but select * doesnt ..

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    3 years ago

    Hi LavanyaI 

     

    I would suggest selecting the column names and maybe put in a where clause in the query to limit how many rows it returns?