How to Fix SharePoint Power BI Map Coordinates and Calculated Dates
Question details
The user needs to correct reversed latitude and longitude coordinates on maps and fix calculated date columns that lack proper date hierarchies when importing SharePoint list data into Power BI.
- Product
- Power BI & SharePoint
- Device & OS
- not provided
- Scenario
- Visualizing and analyzing SharePoint list data within Power BI desktop or web reports.
- Observed behavior
- Map locations display incorrectly due to reversed coordinates, and SharePoint calculated date columns are imported as text formats instead of functional date hierarchies.
Ensure you have editing permissions for the SharePoint list and access to the Power BI Desktop file to modify data types and column settings.
Correct Coordinate Mapping and Data Types in Power BI
Fix reversed map locations by manually verifying data types and assigning the correct data categories to latitude and longitude fields.
Power BI's map visuals rely on accurate data categorization. If SharePoint passes the coordinates ambiguously, Power BI may reverse them or fail to plot them correctly.
Open your Power BI Desktop file, navigate to the Data view, and select your coordinate columns. Ensure the 'Data type' in the top ribbon is set to 'Decimal Number' rather than Text.
Click on the Latitude column. In the Column tools ribbon, find the 'Data category' dropdown and select 'Latitude'. Repeat this process for the Longitude column, selecting 'Longitude'.
Switch to the Report view and select your map visual. Drag the categorized Latitude and Longitude fields into their respective, specific field wells rather than relying on a generic 'Location' field.
Use Power Automate for SharePoint Calculated Dates
Bypass the issue of calculated columns importing as text by writing the calculated result into a standard Date column using a Power Automate flow.
Looking for a Lightweight Alternative for Data Management?
While Power BI is powerful for complex enterprise analytics, everyday data visualization and tracking can often be handled more easily in spreadsheet software. WPS Office offers a free, lightweight suite that includes a powerful spreadsheet tool for building custom dashboards without complicated data connections.
Frequently Asked Questions
Why does Power BI read my SharePoint date column as text?
SharePoint calculated columns often return underlying values as string formats rather than strict date data types. When Power BI imports this data, it defaults to Text, which prevents the automatic generation of date hierarchies.
How do I enable date hierarchies if my column is correctly typed?
If your column is set to Date or Date/Time but hierarchies still do not appear, go to File > Options and settings > Options > Current File > Data Load in Power BI Desktop, and ensure the 'Auto date/time' checkbox is selected.
Can I fix the coordinate reversal directly in SharePoint?
While you can rename or swap columns in SharePoint, it is generally safer and more efficient to enforce the correct data category mappings (Latitude and Longitude) within Power BI's Data model to prevent breaking existing SharePoint views.
