Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Description:
Using Microsoft Exchange Online connector, we can connect to an Exchange mailbox account and extract email contents into Power Query. However, when we filter some CSV files from the mail attachments and want to combine them into one query, a message pops up saying “We didn’t recognize the format of your first file. Please filter the list of files so it contains only supported files (Text, CSV, Excel, workbooks, etc.) and try again.”
These files are all CSV files and have the same table structure. If we click on any Binary content in a cell, it will navigate to the file and extract all data into Power Query correctly from the CSV file. So this operation should be supported.
Repro Steps:
Environment:
Power BI Service version13.0.15854.62
Workaround:
Since this problem does not occur in Power BI Desktop, we can first connect to the same mailbox account in Power BI Desktop with Microsoft Exchange Online connector, extract the AttachmentContent column and combine all CSV files into one query in Power Query Editor. Then copy this query and paste it in Power Query Online. Then this query can be saved in the dataflow without any problem.
Author: Jing Zhang
Reviewer: Kerry & Ula
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.