Forum Discussion

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

Icon for Power BI Team rank

Power 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
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
  Microsoft 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
    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