Forum Discussion
DashboardEMECH
Helper II
6 years agoAccess Database Engine Error
Hi, I have created a Power BI Report which reads an email from the Outlook, extracts the Excel attachment and performs the query function on the excel data. New emails are sent every day and Pow...
- 6 years ago
yes, CSV is much better. It also loads quite a lot faster into Power BI compared to Excel.
DashboardEMECH
Helper II
6 years agoWhat if I use csv format instead of xls. Will that help?
Also will try to see if Power Automate helps in converting an attached in the email from xls to the new format.
lbendlin
Super User
6 years agoyes, CSV is much better. It also loads quite a lot faster into Power BI compared to Excel.