Forum Discussion
need help with Google docs data
i am trying to connect to a google doc but how do i get the data?
Any advice is grateful.
Hi Anonymous ,
In fact, that is a sample scenario about how to get the root path of the shared file. (it does not mean to move your file to onedrive)
If you use excel connector with file URL(root path of excel file that stored in google sheet), it can be refresh automatic after you update its credentials.Google spreadsheet integration
Regards,Xiaoxin Sheng
4 Replies
Hi Anonymous ,
I'd like to suggest you use 'File.Contents' to get data from the root path of shared network file link:
Use OneDrive for Business links in Power BI Desktop
For analysis word document in power bi, you can take a look t following links:
Extract tables from word document
Notice: file connector does not work for URL which contains redirection or other authorizations.
Regards,
Xiaoxin Sheng
Hi Anonymous ,
In fact, that is a sample scenario about how to get the root path of the shared file. (it does not mean to move your file to onedrive)
If you use excel connector with file URL(root path of excel file that stored in google sheet), it can be refresh automatic after you update its credentials.Google spreadsheet integration
Regards,Xiaoxin Sheng