Select to view content in your preferred language

Feature layer integration into relational model

75
0
Monday
Status: Open
LiamCurrie
Occasional Contributor

I don't know if this is realistic but it would be an enormous usability increase if a feature layer could be linked to the Power BI data model. For example, I pull a custom boundary file from my organization's GIS portal and then link the boundary IDs to my data table in Power BI. This would let me use those boundaries as filters for creating symbology just like I would with any normal visual.

Currently I need to join my data, except that using best practices, my data is in a star schema, so the ID is repeated millions of times in my fact table. I can join the data but then I only have the option to use the first row match or to aggregate the data, which doesn't allow me to customize or to join multiple attributes. Any of my custom measures that utilize multiple DIM tables are not functional any more. My option is to create a new aggregated table and build all of the measures I want into that table as set values to join with the feature layer. That's not practical.