Forum Discussion
Getting 'Can't Display the Report' error on selecting the Table inside Semantic model
I have created a pbix file using DirectQuery model. There are multiuple queries inside this pbix file and some of them have 350+ columns as well.
In app.powerbi.com site, after selecting the Workspace -> Select the Semantic Model. We can see the below window:
[Image 1]
Here, the Tables will be listed on the right side. If we select the checkbox besides the table name,
[Image 2]
we used to get a table with all the columns inside that Customer table selected. This used to work like this before. Last time, I created report like this was during April - May 2024.
But, now when we try to create report like this in the same way, it tries to load the report like this
[Image 3]
and then we are getting the below error.
[Image 4]
Note: There are no changes in the pbix file.
The same window can be accessed from OneLake data hub as well.
[Image 5]
OneLake data hub -> Select Workspace -> Select Semantic Model
[Image 1]
From here also, same error is coming.
When I checked the browser network calls, I can see the below request is getting an error:
So, if this is a new restriction imposed in the PowerBI service, could you please help us with some documentation or provide any clarification on why we are getting this error.
3 Replies
Hi, sreejithsreefin
I am glad to help you.
In my testing that one did not have this problem:
Although you mentioned that your pbix file was not modified, I would recommend that you check the data source to see if the data source was changed, as well as checking that the connection to the data source is working to make sure that the data source is not disconnected or experiencing other connectivity issues.
Also check if you have the necessary permissions to access and edit the semantic model. Remember to double check that the gateway connection is working
Since I don't have a table with so many columns, I would suggest you try reducing the columns to test if the problem still exists.
Of course you can also recreate a pbix file and publish it to Power BI Service to see if the problem persists.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Anonymous ,
Thank you so much for your response.
There is no change in data source as well. Gateway connection and necessary permissions are there. We are able to select muliple fields, say about 150+(The exact count of fields with no error is being tested only). This issue occurs only when we select all the fields together. I think this is about the number of columns being selected. This was working till last April/May.
Update:
I have tried selecting fields one by one and I am able to select upto 242 columns manually without any error. While inspected the network calls, the width value is 11525.25mm.
When I try to select the 243rd cloumn, it will show the error:
Report is invalid. ErrorCode: rsOutOfRangeSize, Details: The value of the Width property for the report section 'ReportSection0' is \" 11572.875mm\", which is out of range. It must be between 0mm and 11557mm.I have tested this for multiple entities/queries in a pbix file and this same error is coming when we does a Select all option for queris with columns > 242.
The same issue is coming while creating Paginated reports also.
In normal report( Semantic Model -> Create Report), this error is not there. We are able to manually select upto 350 columns and didn't receive this error.
Anonymous
