Forum Discussion
Advocate IIError updating while connecting Google Sheet
I have a dashboard that is configured to connect to the Google Sheet table.
When updating the dashboard climbs error as in the picture
there is no field in the table BUT actually it is
If 5-6 times in a row to poke on "Update" - it can in an error list other fields which type are not present though they actually are. With 5 times can be updated without problems. And well, it is guaranteed to be updated without problems if you close PB Desktop and then open it again.
What could be the problem ? how do I avoid this error ?
2 Replies
v-chuncz-msftCommunity Support
I cannot reproduce it with the latest version of Power BI Desktop. You may check code that Query Editor is creating with each step in The Advanced Editor.
- a9126030767
file with this error in any version PBI
https://drive.google.com/file/d/1OuEMS-Wl9bixrXNjUsiLvX4ISm91wUgT/view?usp=sharing
GoogleSheet (source) - here https://docs.google.com/spreadsheets/d/1BmAUFX1-Zw0KTa8Sm90917uimk9iQl9YQDTayuG1hak/edit#gid=1377982721
