Forum Discussion

marry's avatar
marry
Helper I
2 years ago
Solved

Refresh Error--- Help Needed

Hi,    I clicked the Refresh in the Power BI report, but it popped up below error message. It shows specific column cannot found. But when I looked back the source data, the column still there. Ca...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi marry 

    According to the error message, there are some steps in Power Query that refer to columns not present in the data source. It is advisable to review the steps in Power Query one by one. When you identify steps with these references, consider modifying or deleting them

    For more information about this kind of error please refer to the linked article:

    https://www.popautomation.com/post/power-bi-column-of-the-table-wasnt-found-error

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

     

m13eam's avatar
m13eam
Resolver III
2 years ago

Hi - this is just a guess as I've never worked with SAP HANA data but I don't think the column is there. The PBI refresh screenshot with an error message is displaying a column without spaces, but the Source Data screenshot shows columns with spaces.

 

Depending on how complex your transform steps are in PowerQuery, you could rename that column to remove the spaces straight after extracting it. Then, all downstream transforms will be looking for a column name without spaces.