topic Re: Power BI Report Server September 2022 Issues in Report Server

Power BI Report Server September 2022 Issues

josef78 — Thu, 27 Oct 2022 15:44:15 GMT

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.

Re: Power BI Report Server September 2022 Issues

josef78 — Thu, 27 Oct 2022 15:45:37 GMT

After upgrading to the September 2022 version, many datasource refreshes started to fail, with a similar error:
"Error: ODBC: SUCCESS_WITH_INFO [01004] Fetched item was truncated." (if PostgreSQL ODBC source)
or "Error: ODBC: SUCCESS_WITH_INFO [01004] String data, right truncated." (if Netezza ODBC source).

Before the upgrade, these refreshes were running fine. I'm still looking for the cause. Does anyone have similar problems?

Re: Power BI Report Server September 2022 Issues

Simonawu — Fri, 28 Oct 2022 01:22:05 GMT

yes, I met the same problem yesterday, this is a new published report in PBI Report server and there is no issues when refreshed in PBI desktop.

Re: Power BI Report Server September 2022 Issues

Simonawu — Fri, 28 Oct 2022 01:35:06 GMT

hello Josef,
Here we we meet a issue after upgrated to Sep 2022 version.
When we edit data in power query, we found that the SQL query scripts would be boxed in Value.NativeQuery automatically, and then we could not click the step option on the right to edit the SQL

Re: Power BI Report Server September 2022 Issues

PSeliger — Sun, 30 Oct 2022 17:10:49 GMT

Hi Josef,

another problem seems to be the deployment of (any?) Custom Visuals.

I tested with Charticulator and WordCloud custom visuals. When I upload to PBI Service (Cloud) any

of my reports work. When I upload (via PBI Desktop Sep.2022 or direct upload) exactly the same report .pbix to my local PBI Report Server (Sep. 2022), I get following error when running the report page with the visuals in browser:

"Can't display this visual, add it to this report first: <custom visual name> ... "

Any workarounds available, yet?

Kind Regards,

Peter

Re: Power BI Report Server September 2022 Issues

d_gosbell — Sun, 30 Oct 2022 22:37:56 GMT

I've also seen a number of people reporting issues with custom visual not loading

Error in visualization of custom visuals. - Microsoft Power BI Community

Custom visuals not rendering after upgrade to Sept... - Microsoft Power BI Community

@Petebro - are either this custom visual issue or the data refresh problem known issues that you are tracking?

Re: Power BI Report Server September 2022 Issues

Medina — Tue, 01 Nov 2022 23:27:36 GMT

Hello,

I was trying to update a Daily Data-Driven subscription and when I click Apply, I got the error message:
An error has occurred.

Something when wrong. Please try again later.

The error message logged on RSPortal file shows the following
WARN|65|BadRequest, Errors: An unexpected instance annotation name 'DaysOfWeek.Sunday' was found when reading from the JSON reader, In OData, Instance annotation name must start with @.| RequestID = s_5b8b8f1f-4f52-4a36-ae9c-037bc450428b

I did not have this issue before upgrading to the September 2022 version.

Any help is greatly appreciated.

Thanks!

Re: Power BI Report Server September 2022 Issues

lnicho — Tue, 01 Nov 2022 23:52:31 GMT

Doesn't support user input parameters like Power BI Service.

Re: Power BI Report Server September 2022 Issues

josef78 — Sat, 05 Nov 2022 09:31:04 GMT

Another (minor) issue, after upgrade to Sep22, end-users report me little slower response.

After investigating logs (executionlog3) on two weeks of production usage data after upgrade, there visible significant change, especially on QueryData execution time (ms between TimeStart and TimeEnd), which is slower.

On my environment, during two weeks before upgrade (on May version) average query execution time is 720ms (on 87k queries daily average).

After upgrade on Sep22, during two week, I have average query execution time 890ms (on 76k queries daily average). It's mean, on my production environment, after upgrade, query execution time is about 24% slower (on little smaller load).

Is there anyone else who see any performance change?

Re: Power BI Report Server September 2022 Issues

josef78 — Sat, 05 Nov 2022 09:34:44 GMT

More and more developers from my company reported this issue in Sep22 release.

It's looks like bug.

In case when ODBC connection returning status "SUCCESS_WITH_INFO", which means successful finish with some warning message, then Power BI Report Server wrongly interpret this as failure (from Power BI Desktop it is interpreted well).

Re: Power BI Report Server September 2022 Issues

jamiestevens44 — Sat, 05 Nov 2022 23:19:55 GMT

The following forum discussion helped me with the same issue:

Solved: Problem altering a subscription / JSON reader erro... - Microsoft Power BI Community

Re: Power BI Report Server September 2022 Issues

josef78 — Mon, 07 Nov 2022 13:55:26 GMT

Hello, I have same issue in this release.

It's relevant for paginated reports subscriptions, with subscription schedule based on Day (with specified weekdays), Week or Month period.

Re: Power BI Report Server September 2022 Issues

jbarta_mlchc — Mon, 07 Nov 2022 18:54:45 GMT

I just upgraded our environment to September 2022 and the date slicers have changed to where you can no longer type the date. You have to first right-click, highlight the whole date, and then it seems like you can type. Is anyone else experiencing this?

Re: Power BI Report Server September 2022 Issues

AgnesB — Tue, 08 Nov 2022 08:27:02 GMT

Same issue here

Re: Power BI Report Server September 2022 Issues

Medina — Tue, 08 Nov 2022 16:18:51 GMT

Hi There,

I am having the same issue; the visual does not get a SetFocus; you can either do what you mentioned in your post or pick a date from the calendar to force Power BI to "activate" or SetFocus on the visual.

I opened the report using the Power BI desktop (RS) September 2022 version to check if the visual exhibited the same behavior in design mode, and it does.

Re: Power BI Report Server September 2022 Issues

jbarta_mlchc — Tue, 08 Nov 2022 16:30:10 GMT

Previously, if I remember correctly, a user just had to click in the slicer field and type the date. Now it seems even using your process it places the cursor on the end of the date and you have to remove it. If you attempt to backspace to remove all of the characters, when you get to the last character it seems to remove the SetFocus and re-enter the default value. The only way I can get the value to remove is by highlighting the whole thing and hitting delete or backspace.

Re: Power BI Report Server September 2022 Issues

Medina — Tue, 08 Nov 2022 16:54:42 GMT

Hi,

I implemented a Subscription Schedule for the report I was having the issue with, as suggested in the link, and it worked.

It was the only report we had running under its schedule. It is a good practice to run the reports under a subscription schedule.

Thanks!

Re: Power BI Report Server September 2022 Issues

DavidLi208 — Wed, 09 Nov 2022 03:21:40 GMT

Hi there, some feedback came into our notice that we think 2 of them are critial:

Folders not accessible which have legacy type report ".rsmobile" in them, but turns good when we restore the previous version(May.2022) and reomove the ".rsmobile" reports then upgrade to version(Sep.2022);
Some users are not able to access the report portal while it tells "An error occurred when invoking the authorization extension." only on the new version(Sep.2022), but they're all good to access the previous version(May.2022) in our another environment restored; (with AD authentication)

Re: Power BI Report Server September 2022 Issues

Irgendware — Wed, 09 Nov 2022 13:51:04 GMT

We have the same problem after upgrading to September 2022 version.
The same error message, we are using PostreSQL and Exasol ODBC source

Re: Power BI Report Server September 2022 Issues

novi_indrayani — Wed, 16 Nov 2022 13:39:09 GMT

Yes, we encountered the same problem. We are using Denodo ODBC data source.
Anyone has a solution?