Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Data Refresh

Hello all,   I am new to Power BI and I'm trying to better understand how the data refresh function works. I am currently working on a report that shows the stock inventory history. I want my repor...
Need Help
ray_aramburo's avatar
ray_aramburo
Super User
2 years ago

There are 2 stages of refresh as I see it:

1) If you are working locally (this means only through Power BI Desktop) no matter how times your data source is refreshed you'll always need to manually refresh from Power BI Desktop to get the latest data.

2) If/When you publish your report to the Power BI Service, you can enable a scheduled refresh. Since you are working with csv files, I would recommend you to host them in a OneDrive/SharePoint/Cloud location so you can avoid using any gateway and then use the SharePoint folder or Web connection to access them. 

 

Now, you mention "the file containing the stock inventory data isn't created until an export is made." You'll need to identify what's exactly the origin of the data that builds the csv, is it a database?, ERP?, existing report?. Once identified, instead of building csv files you'll aim to connect to that data directly. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Regarding your first point, I am working locally in the Power BI Desktop. I am not as concerned about getting the latest data in the desktop as I am about having the latest data on the Power BI Web Service. 

     

    I've already published my Product Stock Inventory report to the web service and have enabled a schedule refresh. When hosting the CSV file in OneDrive, would I still need to manually export the CSV file, and change the name to match the original, to my OneDrive to get the latest data? 

     

    Do you have any other clearer intructions on how to complete this?

    • ray_aramburo's avatar
      ray_aramburo
      Super User
      2 years ago

      So, if I understood correctly, your issue relies that the data source needs to be manually updated on daily basis, and because of this, it has a different name every day. Is that correct?

      If that's the case, could you specify from where do you need to extract the csv files?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Yes our product stock inventory is hosted on a website and the data from that can then be exported into a CSV file. Meaning that I have to manually export a CSV file everyday to get the latest data. And yes these CSV files all have a different name, with the date and timestamp that it was created in the name.