Forum Discussion
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" contains 44 rows and 22 columns.
And I'm completely unable to view the data in it using Power BI. I'm trying to create a new paginated report, but when I select more than ~10 columns then it just sticks forever loading. I tried to save the Report and open it to view but it's the same - it is just loading forever.
Any ideas how to fix this?
How are people supposed to use Power BI with real data if it's even unable to load a small 22x44 table?
If I select just few columns then it works:
8 Replies
rpatkarPower BI Team
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.
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.
bradsyMicrosoft Employee
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.
