topic dataset refresh error in Service

dataset refresh error

Maha16 — Sat, 07 Dec 2024 13:24:48 GMT

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

Re: dataset refresh error

Expiscornovus — Sat, 07 Dec 2024 13:33:22 GMT

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-found

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

Re: dataset refresh error

SaiTejaTalasila — Sat, 07 Dec 2024 14:50:28 GMT

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

Re: dataset refresh error

Ajithkumar_P_05 — Sun, 08 Dec 2024 10:02:14 GMT

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

Re: dataset refresh error

Anonymous — Fri, 13 Dec 2024 03:24:02 GMT

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