Card (New) not publishing (error fetching data)

[Koy]

I have a dashboard that was working fine until yesterday, and now when I publish and view in service the cards are no longer funtioning (works fine on DB, shows error in service).  I completely deleted the cards I had before and rebuilt them trying to find the issue. Now one of the new cards works, and the remainder do not.  I have tried to rearrange things to see if that helps, tried removing elements, trying everything, but nothing works.   Screenshots below
 Service view:

Desktop view:

[Anonymous]

Hi @Koy

I tested it according to your description, but unfortunately, I couldn’t reproduce your error.

Desktop:(2.132.1053.0 64-bit (August 2024))

Service:(Service version:13.0.24209.56)

You can remove all the conditional formatting from the cards as a workaround.
Error fetching data for this visual - Mobile Layou... - Microsoft Fabric Community

You can also create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support:  https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to:   How to create a support ticket in Power BI - Microsoft Fabric Community

Thank you for your understanding.  

Best Regards,  

Jayleny  

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

[Koy · Accepted solution]

I think what you were missing here was conditional format on the reference labels.  I found that when that conditional format was the same as the format on the Accent bar it would not publish correctly.

My solution was to create a new measure that determined the color.

IND LE Color = Switch(

    True(),

    [ACvsLE]<0,"#FF0000",

    [ACvsLE]=0,"#e56e1d",

    [ACvsLE]>0,"#59a33a"

)

In the conditional formatting of my refernece labels, I used Field Value and selected the new color measure.  That solved all my publishing issues.  

[Koy]

This morning I have tried rebuilding the cards to see if there is something wrong in my process.  The rebuilt card will work in service for a while until I add another card. 

[Anonymous]

Hi @Koy 

You can use Google or Dropbox or onedrive to share the pbix files with me.

Best Regards,

Jayleny

[Anonymous]

Hi @Koy 

Based on my testing, the issue did not reproduce. Could you please provide a sample PBIX file that can reproduce the issue, as well as the version number of Power BI Desktop you are using?

Best Regards,

Jayleny

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

[Koy]

Jayleny,
I have been able to recreate my issue with a dummy data set...
Table:  1_BPC 

Measures:  (NOTE the base measure NR does not specify a scenario that scenario AC and OL can be toggled between depending if we are looking at ACTUAL data or FORECAST)

NR = round(CALCULATE(  

    sumx('1_BPC', '1_BPC'[FIN_DATA]), '1_BPC'[PL_PLACEMENT]="NR")/[FX],0)  

NR LE = round(CALCULATE(  

    sumx('1_BPC', '1_BPC'[FIN_DATA]), '1_BPC'[PL_PLACEMENT]="NR", '1_BPC'[Scenario]="LE")/[FX],0)  

NR BP = round(CALCULATE(  

    sumx('1_BPC', '1_BPC'[FIN_DATA]), '1_BPC'[PL_PLACEMENT]="NR", '1_BPC'[Scenario]="BP")/[FX],0)  

NR PY = round(CALCULATE(  

    sumx('1_BPC', '1_BPC'[FIN_DATA]), '1_BPC'[PL_PLACEMENT]="NR", '1_BPC'[Scenario]="PY")/[FX],0)  

NR v PY = Round(([NR]-[NR LE]),0)

NR v PY = Round(([NR]-[NR BP]),0)

NR v PY = Round(([NR]-[NR PY]),0)

NR vs LE Indicator =

if([NR v LE]>0,UNICHAR(9650),if([NR v LE]<0,UNICHAR(9660),UNICHAR(9640)))

FX = 1.25

With that I built a basic CARD(new) and that appears to render in SERVICE

I then added a CARD(NEW) with more formatting.   Rounded corners, accent bar, etc.  That still seems to work fine with one EXCEPTION...  If I have NR v LE in the detail field, the card will not work in service.  HOWEVER, I can have NR v BP and NR v PY as details and it works just fine. 

DESKTOP:

SERVICE

[Koy]

I have also tried to do this without using an FX conversion factor and issue persists.  I thought that might be the issue originally as my volume vs LE is showing but my $$ vs LE will not.  Just another wrinkle...

[Koy]

Forgot to add...  Accent bar highlighting...  Rule based conditional formatting on NR v LE
NR <= 0 is red

=0 is yellow

>0 is green

I just changed my boxes to have conditional formatting and it breaks and works when I remove the accent bar.  If the accent bar is testing the same measure as diusplayed in the Detail value, the error fetching data occurs.

[Koy]

I will work on creating a small data set I can share.

[SaiTejaTalasila]

Hi @Koy ,

Is your report published on premium capacity workspace?.No, Please check whether the same issue occurs on premium capacity workspace or not.

Thanks,

Sai Teja 

[Koy]

I have been trying it in a premium space and my own workspace, both have the error.  Also had aother users view it in the premium to confirm they see it same as me and they do.