Power BI stability with Google Sheets

[ThibautPeyret]

Hello,

I'm trying to build a Power BI report based on a Google Sheets file, but I'm encountering some stability issues.

The data loads fine on the first try but if I click on the refresh button, an error message pops up saying that there is a column not found... but the column does exists and it didn't applied any modification to the query. Funny other thing : by clicking on the refresh button 4 or 5 times, I have the same error message but the "missing column" is not always the same. After clicking several times on the refresh button, the loads works well sometimes while I did not do any changes between the refresh attempts.

Do you think that there is an unstability between Power BI and Google Sheets? Also, the google sheets values are accessed & changes by several people at the same time (the column remain the same though). Do you think that it has an impact?

I'm eager to read you all 🙂

++

Thibaut

[dax]

Hi @ThibautPeyret , 

You said that when you refresh the data of Google sheet, you will get error. So if  no user change the the data when you connect to google sheet , will it prompt the error ? I am not sure whether this cause the problem , you need to try it. And it said that the colum didn't exist, I think you need to check your M code (each step) to see whether the syntax is wrong.

Best Regards,
Zoe Zhi

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

[ThibautPeyret]

Hello Zoe (@dax),

Thanks for the quick response 🙂

Maybe I have not been precise enough.

• The refresh is done on Power BI desktop (by clicking on the refresh button), not on the Google sheet side. I'm adding 2 screenshots : one showing the error "missing column", the other showing the query with the column that exists and without any red color.
• I locked the file to be sure that no one has access to but the issue is still happening 😞
• What's a M code? I double-checked and the syntax is the same for all columns, no invisible space at the end of the document...
• I have one other hint : the columns that are often flegged as "missing" are always the Google Sheets columns that have values calculated from Vlookups, no raw values. Do you think that it could cause an issue ?

  Error message of missing columnScreenshot of query, the Area column does exists