Forum Discussion

Justair07's avatar
Justair07
Resolver I
7 years ago
Solved

Looking for Tips on Storing Data

Hi,   I know a lot of you will read this question and suggest that I connect directly to the source db. Unfortunently, that is not an option in this case, yet.   I'm new to Power BI so I'm not ev...
Need Help
Tips and Tricks
  • Brysonds's avatar
    Brysonds
    7 years ago

    You can point Power BI to the local file that is being updated each day. Whenever you refresh the data in Power BI, it will read whatever is in the excel file. You can refresh manually from the desktop client and push the update to the web service, or you can schedule an automatic refresh fro the web service. 

     

    Once you have connected Power BI to an import source (like excel), the data is contained in memory and stores the table in a compressed format within the Power BI file. Refreshing the data simply replaces the table with the new data.

     

    If you are trying to build history in Power BI, but not in the source file, I don't believe this can be done.

     

     

Brysonds's avatar
Brysonds
Helper III
7 years ago

You can point Power BI to the local file that is being updated each day. Whenever you refresh the data in Power BI, it will read whatever is in the excel file. You can refresh manually from the desktop client and push the update to the web service, or you can schedule an automatic refresh fro the web service. 

 

Once you have connected Power BI to an import source (like excel), the data is contained in memory and stores the table in a compressed format within the Power BI file. Refreshing the data simply replaces the table with the new data.

 

If you are trying to build history in Power BI, but not in the source file, I don't believe this can be done.

 

 

Justair07's avatar
Justair07
Resolver I
7 years ago

Brysonds Thats exactly the answer I needed. Thank you. It looks like I will have to go the middleman route with Access so I can keep a history.

 

Thank you!