Data changing on refresh and error for first row as headers

[Anonymous]

Hi All, 

I am currently facing two issues. 1. data refresh changing data 2. Error refreshing the data 

1. The data gets changed whenever I hit data refresh button. The sheet is connected to google sheets and it changes its data in the column and brings in data from another column. This mixes up th data and this happenes every time.

2. I am unable to 1 row as column header. Whenever I do that in query editor and referesh it given an error. Otherwise, the data referesh runs smoothly. 

Thank you! Looking forward to the Solutions. 

[v-lid-msft]

Hi @Anonymous ,

If you use the web connector to connect the google sheet, it may be incompatible, you can try to download as XLS and test the XLS file in Power BI Desktop.

you can try to follow this document  to connect google sheet correctly.

For the second question, Does it occur after your connect the google sheet, please open advanced editor in power query editor and share your M query formula to me if you don't have any Confidential Information.

BTW, set the first row header works fine in my google sheet.

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more