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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors