Is there any way to set a latitude and longitude attribute type for a dimension?

Andrew Hopkinson 6 Reputation points
2023-10-31T19:35:42.0066667+00:00

I am trying to connect from Power BI to an Analysis Services Cube (2016) using the live connection and a map visualizer. Is there anyway to define the latitude and longitude in Visual Studio for the dimension attribute so Power BI picks it up? I notice there are a bunch of Geography types in VS but I don't see lat and long. The only way seems to be to import the data into Power BI, and then change the type there. I would like to avoid that. Thank you.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,208 questions
0 comments