Forum Discussion

Layorzi's avatar
Layorzi
New Member
10 years ago
Solved

Connecting to a DB that refreshes

Hi all, I will simply describe the situation: I have a website that gets information once a day (updates at midnight). I want my Power BI to update the data it contains every day, while keeping ...
Need Help
Tutorial Requests
  • ankitpatira's avatar
    ankitpatira
    10 years ago
    Layorzi in power bi desktop or service when you do Refresh either manually or scheduled your data model is preserved ( ie all your tables columns and measures) only data is refreshed. It is full refresh that is all your data will be replaced with what's in data source.
  • Anonymous's avatar
    Anonymous
    10 years ago

    Layorzi I would suggest you think of this in two steps.

    1) Write your website data to a "location" (this could be database table, excel spreadsheet, flat file, etc)

    2) Build your business logic in Power BI Desktop

     

    This approach allows you to keep your data seperate and append your new data into a file/table. Then, all you would need to do in Power BI is schedule a refresh which would include the new data.

    All your business logic - measures/calc columns will stay the same, and the underlying data will change per your process.

     

    Keeping your data seperate also allows you to access your data via other tools if you need to in the future.

Layorzi's avatar
Layorzi
New Member
10 years ago

Hi Guys!

Thank you very much for the help.
What i did eventually was to go to Edit Query.
Then go to the first step --> Source.
Double click and add the new page (in my case it is ok, i do it manually once a week).
And everything is stored!

 

Once again, Thanks!