dataset refresh error

[Maha16]

I have clicked  on demand refresh on the report which is published to power bi service. But getting this dataset refresh error.

  can anyone help me with this

[Expiscornovus · Accepted solution]

Hi @Maha16,

It looks like one of the columns (ivt_lineofbusinessid) you are using in the dataset does not exist anymore or has changed in your Semantic Model. 

Have a look at the below:

https://learn.microsoft.com/en-us/power-query/dealing-with-errors#the-column-of-the-table-wasnt-foun...

https://community.fabric.microsoft.com/t5/Power-Query/Data-refresh-gives-an-error-quot-Column-not-fo...

[SaiTejaTalasila · Accepted solution]

Hi @Maha16 ,

Please download the report pbix file and try to fix that error.As per the attached screenshot some columns missing in your dataset/semantic model table.Please take necessary actions and fix that issue in transform data.

I hope it will be helpful.

Thanks,

Sai Teja 

[Anonymous]

Hi @Maha16 

Has your problem been resolved? If so, could you mark the corresponding reply as the solution so that others with similar issues can benefit from it?

Best Regards,

Jayleny

[Ajithkumar_P_05 · Accepted solution]

Download the PBIX file and refresh the specified table in Power Query. This will help you find any missing columns.

[SaiTejaTalasila · Accepted solution]

Hi @Maha16 ,

Please download the report pbix file and try to fix that error.As per the attached screenshot some columns missing in your dataset/semantic model table.Please take necessary actions and fix that issue in transform data.

I hope it will be helpful.

Thanks,

Sai Teja 

[Expiscornovus · Accepted solution]

Hi @Maha16,

It looks like one of the columns (ivt_lineofbusinessid) you are using in the dataset does not exist anymore or has changed in your Semantic Model. 

Have a look at the below:

https://learn.microsoft.com/en-us/power-query/dealing-with-errors#the-column-of-the-table-wasnt-foun...

https://community.fabric.microsoft.com/t5/Power-Query/Data-refresh-gives-an-error-quot-Column-not-fo...