Forum Discussion

Ilya-Tester's avatar
Ilya-Tester
Regular Visitor
3 years ago

Paginated Reports never load 10+ columns

Hello.   I've created a new empty Power BI service account. I need to it to learn Push Datasets API. I'm creating a dataset with tables and fill them up with my data.   My biggest table "forms" ...
Need Help
rpatkar's avatar
rpatkar
Icon for Power BI Team rankPower BI Team
3 years ago

Thank you for reporting! We identified this as a bug and fix will be released in coming weeks. For now, as you already figured out, workaround is to select one column at a time till you have selected all columns of interest. Somewhat related, when viewing wide tables, it's useful to use View / 'Web layout' so you can see all columns on screen, rather than the 'Print layout' that only shows 4 columns on the page.

Ilya-Tester's avatar
Ilya-Tester
Regular Visitor
3 years ago

Hello rpatkar,

 

That's good news. At least it wasn't a problem in our setup.

Regarding your advice with web layout - there is no difference, both layouts don't work when you select all columns in certain cases.

  • bradsy's avatar
    bradsy
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    Hi Ilya-Tester,

     

    We are not able to reproduce the issue. Can you open the dev tools and let us know what is going on in the network traffic and let the report keep running until it errors out? We can also use the X-Ms-Root-Activity-Id value from the 'render' request so we can look at backend traces.

    • Ilya-Tester's avatar
      Ilya-Tester
      Regular Visitor
      3 years ago

      No errors appear in the console when load fails. There is a standard bunch of messages on load:

       

      But when I select my "forms" table (only it is failing to load, other tables load fine) then it goes into infinite loop of "render" requests: https://recordit.co/moDmTRGF6A (demo video)

       

      I tried to wait for a very long time, but it just shows "session expired - reload the page" at some moment.

       

      X-Ms-Root-Activity-Id: fe0ab9b8-573b-93a3-00d2-99ea630f07a1
      • bradsy's avatar
        bradsy
        Icon for Microsoft Employee rankMicrosoft Employee
        3 years ago

        Hi Ilya-Tester,

         

        Thanks for the RAID. From the backend trace, it looks like there is no data returned and no error for the rendering part of the request. We do look to have an existing bug we will fix if no data is returned, the spinner never goes away.

         

        One other thing you can try is to do the same thing in a PBIX Power BI report to see what the behavior is there when you select the whole table.