Forum Discussion
Power BI stability with Google Sheets
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,...
dax
Community Support
Community SupportHi Anonymous ,
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.
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