Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Reporting Process Improvements with Power BI Pro?

Hello everyone,   I am trying to get tips on how we can maximize our efficiency with our reporting process.   Currently we use alteryx to do transformations with our data and spit out a giant cs...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , for incremental, please refresh

These two with the Append Data method

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

 

Latest file from the folder

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711

 

Incremental Load - Traditional
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-or-date-instead-of-the-default-datetime/

 

For Emails -

email scheduler
https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh
https://powerbi.microsoft.com/en-us/blog/e-mail-subscription-time-based-scheduling-now-available/

Alert
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
https://www.bluegranite.com/blog/from-alerts-to-actions-power-bi-alerts-and-microsoft-flow