Solved: Unable to deploy pbix to report server

smccafferty · ‎08-30-2022

I'm having trouble deploying a pbix file to our report server.

I did read that versioning can be key here, so I've ensured that I have matching versions (dates are very close). Running Power BI Report Server version 15.0.1107.166 (December 6th, 2021). My desktop version is 2.97.5901.0 (64 bit, September 2021).

Here's a description of what I'm seeing:

I chose "save as" and I'm promoted to select the server & location. I select https://servername/reports, and then I see the folder list. I click on the folder I'd like to save to.

I hit save. My desktop app freezes for (about) 2 minutes. I see the pop-up (as expected) "Saving to Power BI Report Server" - the wheel is spinning. It goes away after about 2 minutes, and I would expect this means the report has been saved to the server.

However, when I look - the report is not there.

Looking in the RSPortal log, this is the error I see:

2022-08-30 11:06:13.6180|ERROR|13|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/folder/report_name' cannot be found.;| RequestID = s_6b5d3b8a-baf3-4f72-ac06-a043e4cb265e

I will mention that my file is large (slightly over 1 GB) so I'm wondering if this could be some kind of timeout issue?

Any ideas? What am I doing wrong?

Thanks in advance, for any help you might be able to give me.

v-luwang-msft · ‎09-01-2022

Hi @smccafferty ,

Power BI Report Server allows uploading report files to the server up to 2GB in size. The limit is set by default to 1GB see details from the documentation

You can upload files up to 2 GB in size, though by default this limit is set to 1 GB in the Report Server settings in SQL Server Management Studio (SSMS). These files are stored in the database just as they are for SharePoint, and no special configuration for the SQL Server catalog is required.

In SSMS connect to Reporting Services on [Power BI Reporting Server]

1.Once connected in SSMS

2.select properties, go to advanced section
3.change MaxFileSizeMb from default value of 1000 to desired new value

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien

View solution in original post

smccafferty · ‎09-07-2022

Thanks @v-luwang-msft

I did know about the size limit, and had already reconfigured things to allow for 2 GB (I believe my file size at the time was 1.054 GB - so it was slightly above the default max).

I did finally figure out the problem. I should have gone more in depth with info about the development of this pbix.

Orgionally it was build in the version of the software that publishes to the cloud. When I tried to switch gears and publish to the report server - it's only then I learned there were two different versions of Power BI. I installed the correct one for what we wanted to do.

Of course just opening my file in the RS version didn't work. I had to change the model a bit, edit relationships, etc. I was able to convert everything that needed it over to something that was RS compatible.

I suspect that despite being able to open it, and work with it, in the RS version of Power BI Desktop - there were still underlying components that hadn't been converted. My file was simply not compatible with deploying to the report server.

I started a new file from scratch, and have added the pieces back one at a time. Publishing at each step along the way (just to keep making sure everything is working). The new file, that has only ever existed in the RS version, works fine.