Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 ?
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.
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=1377982...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 69 | |
| 46 | |
| 44 | |
| 28 | |
| 19 |
| User | Count |
|---|---|
| 199 | |
| 129 | |
| 102 | |
| 69 | |
| 55 |