The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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...