Excel data source is not showing tables even after defining name to excelsheet.
I have exported template from Dynamics 365 for account entity. I want to use that template as my source so I have performed following steps:
- Defined name excel by navigating to formula> define name
- file type is .xls
- created xls connection as source
But when I expand the tables then it is showing me no table