Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
absr
New Member

MicroChart didn't work in PBI Report Server: Unable to load data for this visual object

Hi PBI group:

    I am a beginer of PBI. I made a simple MicroChart in PBI Desktop and published it to PBI Service(app.powerbi.com). It worked in 

Desktop and PBI Service as below:work in desktop.png

 

work in PBI Service.png

 

But when I uploaded it to PBI Report Server , it did't work and showed message of  'Expression 3 could not be translated into a DataShapeGroup or Measure expression'.

 

not work in report server1.pngnot work in report server2.png

 

The data I used are here:

 

sheet9.pngsheet10.png

 

As a beginer , I've no idea of this , need your help, thx.

 

1 REPLY 1
jaweher899
Super User
Super User

The issue with your MicroChart in Power BI Report Server could be due to the fact that MicroCharts are not supported in Power BI Report Server. MicroCharts are a feature of Power BI Service and Power BI Desktop, but are not available in Power BI Report Server.

As an alternative, you can use a standard visual, such as a bar chart or column chart, to display your data. To create a bar chart or column chart, follow these steps:

  1. Select the data that you want to use in the chart.

  2. Go to the "Visualizations" pane and select the bar chart or column chart icon.

  3. Drag the desired fields to the appropriate sections of the chart (such as the X axis and Y axis).

  4. Adjust the formatting and style of the chart as desired.

This should allow you to display your data in Power BI Report Server, even though MicroCharts are not supported.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.