Forum Discussion

absr's avatar
absr
New Member
3 years ago

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:

 

 

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'.

 

 

The data I used are here:

 

 

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

 

1 Reply

  • jaweher899's avatar
    jaweher899
    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.