topic Re: Power BI report published to service loses basemap and data color settings in ArcGIS for Power BI Questions

Power BI report published to service loses basemap and data color settings

PaulHuey — Tue, 19 May 2020 16:08:53 GMT

I have a Power BI report with the standard ArcGIS visualization that is published to a Power BI service tenant that uses the Street Basemap and custom colors for Symbol Color. This report had been rendering properly for several weeks but now renders with the Light Gray Canvas basemap and default Symbol Color values. This happens on multiple browsers even after the browser cache is cleared. I have also attempted to re-publish the report but it still renders with the incorrect settings.

Did ESRI push a change that altered rendering in Power BI service for this visualization?

Re: Power BI report published to service loses basemap and data color settings

DavidCresp — Wed, 20 May 2020 16:12:00 GMT

I am finding that setting are not saving within Power BI Desktop. I set everything up for a one country boundary map go to another tab and back again and all settings are lost. This seems to have been an issue previously and was fixed but is now back again.

Re: Power BI report published to service loses basemap and data color settings

JonEmch — Thu, 21 May 2020 19:52:43 GMT

Hello all,

I am a representative of Esri Technical Support. We are currently tracking this behavior that occurs in PowerBI Online. Would you please reply to this thread with the region location of your PowerBI Tenant? You may access this information by going to PowerBI Online and clicking the question mark next to your profile picture.

At this point in time, we know that this behavior is occurring on certain PowerBI Online datacenter regions. If you have maintenance, I would advise you to open a case with us.

Re: Power BI report published to service loses basemap and data color settings

PaulHuey — Thu, 21 May 2020 20:17:48 GMT

Jon,

The data region is North Central US (Illinois).

Re: Power BI report published to service loses basemap and data color settings

JonEmch — Thu, 21 May 2020 21:34:45 GMT

That is consistent with what we have been seeing on our end. When I get updates (and a resolution) to this matter, I will update you with that knowledge.

Re: Power BI report published to service loses basemap and data color settings

DavidCresp — Fri, 22 May 2020 00:34:38 GMT

I am in Australia. I expect the South East server. Great to hear that you are onto this and it will be fixed soon. It is making the visual unusable. Hopefully the fix will also fix the issue that has been there for some time that the map legend can't hold colours when you use colours and size in a map.

Re: Power BI report published to service loses basemap and data color settings

JonEmch — Fri, 22 May 2020 12:50:05 GMT

Anytime David, I aim to please. Could you comment on your secondary issue a bit? Are you by any chance attempting to modify a default color ramp with custom colors?

Re: Power BI report published to service loses basemap and data color settings

PaulHuey — Wed, 27 May 2020 15:10:14 GMT

Jon,

Thank you for your response. Any progress towards a resolution on this

issue? We have reports in production that use this functionality.

Thanks,

Paul

Re: Power BI report published to service loses basemap and data color settings

JonEmch — Mon, 15 Jun 2020 17:08:54 GMT

Hey there Paul,

I have been able to confirm with multiple users that the Power BI Online persistence issue ICM – 187310866 has been resolved. Please let me know if you are still running into issues.

Re: Power BI report published to service loses basemap and data color settings

DavidCresp — Mon, 15 Jun 2020 17:16:15 GMT

Hi Jon, the June version of PBI Desktop has solved a number of issues but the issue described above is still an issue. Yes this issue is when trying to use custom colours. I need to be able to use custom colours to fit in with the Desktop colour scheme.

Re: Power BI report published to service loses basemap and data color settings

DavidCresp — Mon, 15 Jun 2020 17:18:10 GMT

Sorry just to clarify the issue that is not yet resolved is the map legend can't hold custom colours when you use colours and size in a map. Hopefully this one can be solved soon as well.

Re: Power BI report published to service loses basemap and data color settings

MichaelOri — Tue, 16 Jun 2020 06:05:50 GMT

So, how do we update the ArcGIS Map for BI tool to the new release?

Re: Power BI report published to service loses basemap and data color settings

JonEmch — Tue, 16 Jun 2020 13:53:18 GMT

Hey Michael,

For PowerBI Desktop, you should be able to download the latest version here. Alternatively if you open PowerBI Desktop, it should prompt you to update.

PowerBI Online should update on its own.

Re: Power BI report published to service loses basemap and data color settings

JonEmch — Tue, 16 Jun 2020 13:57:01 GMT

Hello David,

There are two known issues with ArcGIS Maps for PowerBI on desktop being unable to store custom symbology:

BUG-000129922 : ArcGIS for PowerBI custom symbology changes back to default color ramp after an external filter is applied.
BUG-000123575 : ArcGIS Maps for Power BI fails to retain the custom symbology after exiting the application

These are most likely related to an overarching issue. If you are able to log a support case with us, I would strongly urge you to do so. That way we can confirm that this is the problem you are running into at which point we can add you to the defects.

Re: Power BI report published to service loses basemap and data color settings

DavidCresp — Wed, 17 Jun 2020 10:24:26 GMT

Thanks Jon, these would certainly cover the issues that I am getting and were obviously not fixed in the June version of Desktop. Is there any expectation on when these will be rectified?

Re: Power BI report published to service loses basemap and data color settings

JonEmch — Mon, 22 Jun 2020 15:42:41 GMT

The status of these defects lead me to believe that there is something in motion to address these issues. Unfortunate, I cannot speak for the Product Team so can't offer anything more than that.