Reinitialize DB subscription caused column headers to capitalize the first letter

[abehrmann]

our DB is a subscriber to a third party that is using a transanctional db replication. 

There was a issue that paused the subscription so they wiped it and reintialized the subscription and now i am recieving the below error messages, which seams that it caused by the column headers first letter being capitalized 

The column 'wodatecompleted' of the table wasn't found. Table: BI_Orders_DT_View

but the column is in the dataset as WoDateCompleted

[v-xicai · Accepted solution]

Hi @abehrmann ,

You can download the pbix file from the report page in Power BI Service, then open in Power BI Desktop to check which visual is broken in Visual pane or which column is created with incorrected syntax in Fields pane, or open up the advanced editor and remove any reference to the 'wodatecompleted' . Then you can determine if add to the visuals or not.

Best Regards,

Amy

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