Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Auto update from local folder

Hello,   I'm very new to Power BI. My situation:   I want to create a report with data from our website. So every night an Excel is send with data from the day before, to an email address which a...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    with Power BI you cannot read all the files of a folder from Google Drive at the moment.

    With OneDrive it would be possible. In my mind you have 2 options:

    1. Upload the files to a OneDrive folder and then load the files from there with Power BI

    2. Create a Power Automate Flow that transfers new files from the Google Drive to OneDrive and then access them with Power BI. As an alternative you could load them into an SQL Server and then access that one with Power BI.

     

    If you need any help please let me know.

    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

     

    Best regards

    Denis

     

    Blog: WhatTheFact.bi

    Follow me: twitter.com/DenSelimovic

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

with Power BI you cannot read all the files of a folder from Google Drive at the moment.

With OneDrive it would be possible. In my mind you have 2 options:

1. Upload the files to a OneDrive folder and then load the files from there with Power BI

2. Create a Power Automate Flow that transfers new files from the Google Drive to OneDrive and then access them with Power BI. As an alternative you could load them into an SQL Server and then access that one with Power BI.

 

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

 

Best regards

Denis

 

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic