You’re offline. This is a read only version of the page.
19
Trying to import data from a desktop Access table into a PowerApps 'new entity.' Stumbled into importing the Access table data via a desktop gateway, mapping the data, etc.
However, would like to clean up the data in Excel and re-import. The 'export an Excel template, copy paste the data, then import' method consistently fails; apparently there is some issue importing"Owning Business Unit;" which, by the way, is null in the source Excel template file.
So, turned attention to trying the "Open in Excel" method to import data.
However, every time I attempt to open the entity in "Open in Excel" I get a message that indicates "Your entity has been successfully opened in Excel, please check your downloads."
However, I cannot find the referenced Excel file.
Would appreciate suggestions on where to look.
Hi @Bubba,
In default, when you click "Open in Excel" option within a CDS entity to import data, the corresponding Excel file would be opened automatically.
In addition, in default, the Excel file would be downloaded into the Downloads folder (the default download path of browser) of your computer as below:
If you have customized the Download path for your Browser, you should go to your custom Download path to find the Excel file.
Best regards,
Kris
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
