Forum Discussion

c_tewalt's avatar
c_tewalt
Frequent Visitor
9 years ago

KPIs imported from Excel cause errors when added to visuals

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!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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