The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
how can I automatically generate a report from Business Central Purchase invoices that will be due in 7 days and automatically notify someone about the upcoming due date?
Bring the data to Power BI and then use Power Automate to query the dataset (to retrieve the invoices being due in 7 days) and the build the other steps like sending an email.
Hello, sorry I am new to powerBI, how can I get the combined actual due date, currently they are separated by date hierarchy.
I don't know your data so I can't really help.