Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |