Forum Discussion

niyati_61's avatar
niyati_61
Helper III
4 years ago
Solved

PBI: Importing Data

Hi all,

 

Currently I'm builing a Power BI Report for Engineering Progress Report data.

 

Regarding the Data: I get 5 Relevant Engineering Excel Files weekly. This Engineering data gets updated every week on Friday.

 

Now, the thing is from each of these Excel files I only need some tables or relevant information.

Eg: From Excel File 1: I need only 4 tables (and the other data (Many sheets) in the file is not required), and similarly with the other 4 Excel Files too.

 

How do I go ahead with data importing in my Power BI File? I mean do I have to always take it from the 5 separate Excel files? Or should I create one main Excel File by myself? How do I automate that?

 

I would like my Power BI Report to be refreshed automatically when I receive the data every week as well.

 

Kindly request support on the matter. 

 

Thank you.

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    My Suggestion : 

    • Store your data on one drive or Sharepoint.
    • Update files manually as and when required.
    • Configure Schedule refreshes on the report so that you dont have to update manually after you update the data.
    • For complete automation end to end would suggest trying power automate.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    My Suggestion : 

    • Store your data on one drive or Sharepoint.
    • Update files manually as and when required.
    • Configure Schedule refreshes on the report so that you dont have to update manually after you update the data.
    • For complete automation end to end would suggest trying power automate.