Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Automatically create a query

Hello, I have a particular dilemma and wtih my search so far I have foud it cannot be done. Pls help me out.   I have a folder where a new excel file will be uploaded everyday. I have found a solut...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    I make a test as below:

     

    I have a folder with many excel files, everyday a new file is uploaded into this file.

    Let to say, yeaterday i have 1,2,3 excel file.

     

    1.Get data ->Folder->enter/browser the folder path(get all files in this folder)->Edit

    2.Combine files

     

    Today, i upload file 4 to this folder, then click on "Refresh All" in Power BI, it will get new data from file 4 into this table

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

I make a test as below:

 

I have a folder with many excel files, everyday a new file is uploaded into this file.

Let to say, yeaterday i have 1,2,3 excel file.

 

1.Get data ->Folder->enter/browser the folder path(get all files in this folder)->Edit

2.Combine files

 

Today, i upload file 4 to this folder, then click on "Refresh All" in Power BI, it will get new data from file 4 into this table

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you, Maggie. That does solve this particular problem.

     

    Once I have uploaded it to the Power Bi online service and scheduled a report refresh, will that "Refresh All" as well?