Forum Discussion

Saide's avatar
Saide
Frequent Visitor
3 years ago
Solved

PowerBI refresh from Excel data source crashes on the only column that has a formula

Good morning All,   I have a PowerBI project with data from an Excel stored on SharePoint. Here and then it happens that no data is loaded after refresh into PowerBI. It is after someone has update...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Saide 

     

    The cause is probably from the formula (=HLOOKUP($A$1;KPI_ACTIVE_COU;ROW()-1;FALSE). From the document of HLOOKUP function, you will see the following argument. Please check where the formula is used. If it is used on the first row, ROW() will return 1, then ROW()-1 will return 0. While 0 is less than 1, which may return this error value. 

     

    ROW function - Microsoft Support

    HLOOKUP function - Microsoft Support

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Saide 

 

The cause is probably from the formula (=HLOOKUP($A$1;KPI_ACTIVE_COU;ROW()-1;FALSE). From the document of HLOOKUP function, you will see the following argument. Please check where the formula is used. If it is used on the first row, ROW() will return 1, then ROW()-1 will return 0. While 0 is less than 1, which may return this error value. 

 

ROW function - Microsoft Support

HLOOKUP function - Microsoft Support

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.