Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Scheduled Refresh Failed from SharePoint Excel File

[ValidateMarkupTags][ccon]Expression.Error: The column '[ccon]Service[/ccon]' of the table wasn't found.. [ccon]Service[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: ServiceMapping.

 

I'm getting the above error message when trying to refresh the Power BI dashboard through Power BI Service. But working perfectly with Power BI Desktop. Any solution to this?

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi Anonymous 

     

    From the error above it says that it cannot find the column called "Service" if you go into the same file with Sharepoint online can you see the name?

     

    Also make sure that there is not a space at the end of the column name?