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:

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.

Card (New) not publishing (error fetching data)

11 Replies

SaiTejaTalasila
Super User
1 year ago
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
  Helper I
  1 year ago
  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.
Anonymous
Not applicable
1 year ago
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
  Helper I
  1 year ago
  I will work on creating a small data set I can share.
- Koy
  Helper I
  1 year ago
  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
    Helper I
    1 year ago
    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
Helper I
1 year ago
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
  Not applicable
  1 year ago
  Hi Koy
  
  You can use Google or Dropbox or onedrive to share the pbix files with me.
  
  Best Regards,
  
  Jayleny
Anonymous
Not applicable
1 year ago
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
  Helper I
  1 year ago
  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.

Forum Discussion

Card (New) not publishing (error fetching data)

11 Replies

Related content

Error fetching data

Error Fetching Data

Error fetching data

Error fetching data for this visual

Error fetching data