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.
Hi all,
I have a dashboard that is pulling data via Google Sheets. On trying to refresh it this morning it returns an error of 'The key didn't match any rows in the table'. On further investigation, it looks like that when PowerBI is looking at the Google Sheets export (done via 'Publish to Web') the sheetname is being lost and is instead coming through simply as Sheet10 hence it can't connect to the sheet that it formerly knew as 'Campaigns Data'.
Has anyone else experienced this? I'm not sure if it's a PowerBI or a Google Sheets problem, but any advice most welcome!
Thanks,
Sam
Hi @Anonymous ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi Daniel,
The solutions presented above don't really help unfortunately as I am still intermittently getting the error.
Thanks anyhow,
Sam
Hi @Anonymous ,
Based on my test, it seemed work on my side:
Could you have tried with below link to get data form Google Sheet:
https://bizone.co.th/2016/09/26/connecting-power-bi-to-google-sheets/
And you could check if you have changed any data for your Google Sheet:
Regards,
Daniel He
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |