KPIs imported from Excel cause errors when added to visuals

[c_tewalt]

I've imported an Excel data model into Power BI Desktop and am trying to show KPIs in the matrix and/or table visual. However, when I pull my KPI status into the values pane for the visual, I receive this Unexpected Error "An error occurred while rendering the report." For this data model, I have 4 total KPIs that I need for reporting. 3 out of the 4 KPIs return this error when I try and add them to the visuals. I have attempted to import the Excel data model into Power BI Desktop a few different times in case it was just a fluke, but the problem persists. I should also mention that the KPIs work appropriately in Excel.

Has anyone else experienced this issue and if so, do you have a solution? Any assistance would be greatly appreciated!

[v-shex-msft]

Hi c_tewalt,

Based on test, I can import excel data model to power bi desktop:

I think the issue may related to your excel workbook, can you provide the workbook which you used to import to power bi?

Regards,

Xiaoxin Sheng