Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a small issue regarding one of my queries.
Target : pull all data (multiples tables) from an HTML file sent daily to email adresse.
Email : outlook exchange
File : HTML file with multiple tables.
Challenge:
1) I am succefully connecting to the outlook exchange.
2) I am succefully drilling down in the attachment.
Problem is coming after, as there are multiple tables, (variable depending on day), one query only allows me to pull one table.
Is there a way around ?
I can append all tables and create X queries but looking if there is an easiest solution.
Thanks
Kind regards
Vivasss
Solved! Go to Solution.
Hi @Vivasss ,
When you connect to Microsoft Exchange in power query, you can filter the daily HTML file in the attachement field first after you expand it.
Then you can click the down arrow to combine these files without appending them one by one.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Vivasss ,
When you connect to Microsoft Exchange in power query, you can filter the daily HTML file in the attachement field first after you expand it.
Then you can click the down arrow to combine these files without appending them one by one.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you provide an example/mock html file with multiple tables so a specific solution can be suggested? Also, this might be a good application for Power Automate with a Flow that is triggered off receipt of the email with your HTML file that then moves the data to another format/location (e.g., csv on SharePoint) prior to Power BI ingestion.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.