Forum

How to get informat...
 
Notifications
Clear all

How to get information from table being updated in Google Drive

2 Posts
2 Users
0 Reactions
59 Views
(@ashwani-singhal)
Posts: 2
Active Member
Topic starter
 

For Dash Board's Pivot Table, I want to use the data that is entered by my colleague in an xl file which is placed on Google Drive (G Drive). 

Please help how to get it.

Thanks

Ashwini Singhal

 
Posted : 08/09/2018 10:21 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Ashwani,

You can use Power Query to get the data from an Excel file saved on Google Drive as described here:

https://social.technet.microsoft.com/Forums/en-US/f83caabb-9729-4d48-b4f2-a2cb5ca0c9f9/import-from-excel-file-xlsx-on-google-drive?forum=powerquery

Mynda

 
Posted : 09/09/2018 12:55 am
Share: