Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello everyone,
I want to ask, who you are using September 2022 release of Report Server in a test or production environment, if you register any problems or other unexpected behavior, please list them here.
I think it would be helpful to share all known issues in one place.
Thank you very much.
Since upgrading to September 2022 QFE build the CPU on our production server is now at 97%, before the QFE build and busiest periods saw CPU at 65% max.
Can you advise? @v-alipat
Hi @Gemw87
We don't observe such consumption changes in any of our test machines, are you sure it's the Report Server process that is taking more now?
Also, do you see it with just one machine or more than one? and could you please specify any computer specifications with which you see it?
Thank you
We are seeing this on our production report server, this has only started to occur since we applied the latest September 2022 QFE last week. Prior to that we never saw the CPU this high.
Upon investigation we're finding that some of the larger reports (150 MB report) when refreshing are causing the report server CPU to hit 100%. This wasn't occurring prior to the latest update.
The top processes when hitting 100% are Microsoft SQL Server Analysis Services, Microsoft Mashup Evaluation Container and WmiPrvSE.exe
The report server spec is -
* Windows Server 2016 Datacenter
* Processor - Intel(R) Xeon(R) CPU E5-2698 v3 @ 2.30GHz (4 processors)
* Installed RAM - 12 GB
* System type - 64-bit OS, x64-based processor
Can you please advise?
Hi @Petebro ,
Please can you help? There are some new issues in latest release of PBIRS, especially first three. Is possible check with product team is these issues are identified and if there is any progress or ETA?
1) ODBC connector failing if data source contains text column with text length greater then 512 characters (with Error: ODBC: SUCCESS_WITH_INFO [01004].
2) Custom visuals not working in new reports when saved from Power BI Desktop September 2022
3) Paginated reports subscriptions schedule based on Day (with specified weekdays), Week or Month period, is not able to create or edit.
4) Little performance drop after upgrade to September 2022
5) Some UX issues with data slicer visual.
Hi @josef78,
I am pleased to bring good news today. We investigated all of the listed issues, please see details below.
1) ODBC connector failing if data source contains text column with text length greater then 512 characters (with Error: ODBC: SUCCESS_WITH_INFO [01004])
The issue was fixed and the fix will be included in the planned QFE release for PBIRS September. ETA for the release is in December, before Christmas holidays.
Workaround: to refresh data through PBI Desktop for RS (I understand it is not a good workaround for cases when you have many reports, or need to refresh often, but it is the way that can help to refresh)
2) Custom visuals not working in new reports when saved from Power BI Desktop September 2022
This issue was fixed as well and fix is coming in QFE. There is a workaround which you can use until the fix is released:
Add a URL parameter to the URL: ?consumePublicCvsWithoutRps=1, and visuals will start working
for example: http://servername/Reports/powerbi/reportname?consumePublicCvsWithoutRps=1
3) Not able to save paginated reports subscriptions schedule based on weekdays
The issue is fixed and fix is coming in the QFE
Workaround: use shared schedules
4) Little performance drop after upgrade to September 2022
We investigated this complaint and tried to reproduce it, but we didn't observe the performance drop. We'll keep an eye on this one.
5) UX issues with data slicer visual
The issue was identified, and now it's being worked on. Unfortunately, fix for this one will not be included in the coming QFE, but we will aim to fix in for January 2023 release.
Thanks,
Alexandra
Hey Alexandra,
I can see there is a January 2023 version of PBIRS, is this officially out including all the fixes??
Hi @mpsrshl and all,
PBIRS Jan 2023 is on the way, should be publicly available today in the Microsoft Download Center.
There will be an announcement here in the community too.
You can check here in the changelog, what is going to be included in the new release: https://learn.microsoft.com/en-us/power-bi/report-server/changelog
Thanks,
Alexandra
Thanks Alexandra for the quick response!
Ok I look forward to the announcement.
A tone of additions once again we have missed out on :')!
Sure thing 😊
The new build shoud be available in the download center now: https://www.microsoft.com/en-us/download/details.aspx?id=55329
Please make sure to follow the safe upgrade instruction: https://learn.microsoft.com/en-us/power-bi/report-server/upgrade
Hi Alexandra,
this is great news.
The date published from PBI Report Server has been refreshed to 12/12/2022, but the version number did not change.
Is the QFE already published?
Mark
Hi Mark 😊
Keen eye! No, the QFE is not live yet. The date changed just because the build is staged to be published, but it will take some time for the bits (and displayed version) to be actually updated. 1 to 2 days usually. There will be a community post about the update, also changelog will be updated.
Thank you,
Alexandra
Great news. Thank you so much.
For first two issues I have confirmation from @v-alipat that hotfix will be probably in this month.
@Petebro is there a fix for the OBDC error?
Error: ODBC: SUCCESS_WITH_INFO [01004] Fetched item was truncated
We use Denodo and have upgraded to September 2022 and our refreshes our now failing with this error.
Do we need to regress back to May 2022 or is there a fix coming?
Hi @Gemw87 , the hotfix for ODBC refresh is coming with a QFE Release planned before Christmas 😊
Hello,
I have a problem with only one user.
When he tries to login this error is shown:
I have tried:
- Remove his accesses and add again.
- Log in on another machine.
Nothing solves it, can someone help me?
Hi there,
My approach to deal with this issue would be:
I hope it helps.
Please, let us know if you were able to solve the problem and how you did it.
-Thanks!
Hey, I extracted the Report Server log, but did not find any useful information for this user. I tried to open a ticket at Microsoft but I didn't get a response from the responsible area.
Hello matheusmalta,
is this issue new in September 2022 release?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
6 | |
5 | |
4 | |
3 | |
3 |