98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Database
Database
Resolved · Low Priority · Version 365
RE: Database
Hi Christopher,
Thank you for the forum question and the nice feedback. I am happy, that you found the course useful.
I found a way of refreshing the dataset in Power BI, without you have to refresh the whole dataset.
An incremental refresh will feed in ONLY NEW data in the data set. This is usually a lot quicker than a full refresh as it is not querying data already in the extract. This will not look at any changes in the original data set, it will only load up new rows of data entered into the database.
I found an article which explain it, but you can find many articles if you search for Power BI incremental refresh
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
I also found a good article about speeding up Power BI
https://www.acuitytraining.co.uk/news-tips/speeding-up-power-bi/ #:~:text=Power%20BI%20reports%20are%20often,fully%20understand%20how%20it%20works.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 19 Jan 2023: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting constant values onlyIf periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter. |