Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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