Auto Refresh Report Data showing error

[Anonymous]

I have created report in Power Bi desktop by connecting to a online Sharepoint source. I have added a new column in the table in  Power Bi for Week No. and generating its visual. However when I am trying to referesh the data by connecting to the online sharpoint source it is showing issue for the visuals where I am using new column. How can we resolve this.

[DataVitalizer]

Hi @Anonymous 

Probably the column used in Power Query was deleted or altered in the data source.

Try verfiying if the format was changed or the column was renamed/removed in the source, in the meanwhile I suggest that you go to Power Query and create a random calculated column with the same previous named in orver to overcome the current issue.

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

[Idrissshatila]

Hello @Anonymous ,

go to power query and check the table that has the error, they will tell you what's the error.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Anonymous]

Hello @Idrissshatila,

Yes I know that the Week No. field I have added in Power Query is not there in the online Sharepoint source I am connecting to refresh the data that's why it showing issue for those visuals where Week No. field is being used. But how to resolve this?

[Idrissshatila]

@Anonymous ,

you need to fix this column because there's an error in it or remove it so you cloud refresh the table.

but now since this column is now part of the table and it's not working that's why you can't refresh it.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin