Data changing on refresh and error for first row as headers

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