cancel
Showing results for 
Search instead for 
Did you mean: 
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
Impactful Individual
Impactful Individual

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Kudoed Authors