Forum Discussion

Tumitran_1576's avatar
Tumitran_1576
Frequent Visitor
9 years ago

How to import data from excel spreadsheet?

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,
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

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