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.
Is there any filtering to the
Source = Exchange.Contents("email@someaddress.com"),
Mail = Source{[Name="Mail"]}[Data],
lines that will allow me to pull just the Outlook metadata I need instead of everything?
Stakeholder wants to track 19 addresses in a single report and it's currently taking 4+ hours to refresh due to the abundance of data being pulled into power query, only to be removed after the fact.
Thanks
Solved! Go to Solution.
I struggled with the same issue, until I decided to use Power Automate to get and filter the mailbox, send the results to a SharePoint list, and then queried the list. Works like a dream.
--Nate
I struggled with the same issue, until I decided to use Power Automate to get and filter the mailbox, send the results to a SharePoint list, and then queried the list. Works like a dream.
--Nate