How to import data from excel spreadsheet?

[Tumitran_1576]

Hi friends,

I am looking for a way to import my data from excel spreadsheet at docs.google.com to Power BI. 

Does that function exist?

Thanks,

[v-jiascu-msft]

@Tumitran_1576

Hi,

You have gotten many good ideas from @vanessafvg.  I just test two ways. Both work well. Please have a try.

1. Publish Google sheet to the web, then use web URL in Power BI Desktop. This isn’t proper for confidential data.
2. Download as Microsoft Excel from Google Sheets. Then get data from excel file. This may be an easy way.

 

Best Regards!

Dale

[vanessafvg]

from another thread elsewhere mentioned the following options;

1. publish google excel as web and  then use that web address as a source in power bi but there might be security concerns

2. use the google api

3. or use the webservice and upload the file from drive

haven't a clue if any work though.