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

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    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.

  • 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