Forum Discussion

Ria_'s avatar
Ria_
Frequent Visitor
6 years ago
Solved

Connect to google drive folder

Hello,

 

I am trying to connect Power BI desktop to a google drive FOLDER that has several files inside. (This link is provided by the client) I want to be able to view all files data just like if I were to connect to a local folder with several files. 

 

I have made sure that the google drive folder shared link has edit ability but when I enter the URL into BI I cannot see any data. (Including view of what I see)

I usually edit the URL to reflect: /export?format=csv at the end of a google sheet and that works, but that is not working for the sharable link provided for the folder.

Has anyone been able to connect to a google drive folder? 

 

 
 
 
Need Help

6 Replies

  • venal's avatar
    venal
    Icon for Memorable Member rankMemorable Member
    6 years ago

    Ria_ 

    Can you please trty to refer the below links.

    https://community.powerbi.com/t5/Power-Query/import-file-from-google-drive/td-p/43218

    https://www.cdata.com/kb/tech/googledrive-odbc-power-bi.rst

     

    If you have any queries, please let us know.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more
    If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

     

    BR

    venal.

    • mtroiano's avatar
      mtroiano
      Regular Visitor
      6 years ago

      Hi there,

       

      I know this was marked as solved but I don't see a solution. I have 2 pretty distinct issues - if I try and connect to a google SHEET in google drive I get an HTML window that asks me to log in instead of data.

       

      My second problem is I just want to store my excel files in Google Drive so they're not reliant on my computer being available. When I try, it says the connection doesn't work as an excel. 

       

      Thanks,

      m

      • IngAndresRojas's avatar
        IngAndresRojas
        Frequent Visitor
        3 years ago

        Hi there @mtroiano

        Were you able to fix it? I'm having this very same issue.

        Thanks!

  • tgpowerbi's avatar
    tgpowerbi
    New Member
    4 years ago

    I still do not see a solution. Am I missing something here?