Skip to main content

Power BI

New

Import 'Geography' Data Type from Excel

Vote (1) Share
Simon Brock's profile image

Simon Brock on 14 Jun 2023 09:57:11

At present, if I import data into Power BI from Excel, where the cell has a Data Type 'Geography', I get the error DataFormat.Error: Invalid cell value '#VALUE!'. Suggestion is to be able to import the data, even if only as raw text, as displayed in the cell.