Datamart connecting to flat file

[ChrisPalmerNZ]

The new datamart doesn't seem to be able to import data from a flat file, unless that file is first imported into OneDrive and served up via SharePoint. Can anyone clarify whether this functionality will be fixed?

[ChrisPalmerNZ · Accepted solution]

I have realised I need a Data Gateway. Without that I need to copy files into a SharePoint share.

Thanks

[v-kkf-msft]

Hi @ChrisPalmerNZ ,

Do you want to connect to local excel, csv, etc. files?

Based on my tests, Datamart is able to successfully connect to local files.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.