Forum Discussion
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 ...
- 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.
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.
ankitpatira
Community Champion
Community ChampionLayorzi 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.