Forum Discussion
import file from google drive
Hi, I have a client that maintains a sales bookings forecast report in a Google Spreadsheet file that is saved and updated within a Google Drive folder. When I follow the PowerBI process to "get...
I would try a couple different troubleshooting things to try to sort this out. First, I would bring the file local, copy and paste and eliminate the Google Drive aspect completely. See if it works. If it does, then there's something up with Google Drive. If not, then it is something to do with the format of the Google Spreadsheet. If it is the latter, you could try some of the other import drivers, like import from Excel, etc. to see if you can get one of them to work.
You may find Ehren's response here useful: https://social.technet.microsoft.com/Forums/en-US/7b8a3017-72ae-40db-911f-34a50e95b928/using-power-query-to-move-data-from-google-forms-to-excel?forum=powerquery