topic Re: PowerBI map bugs? in ArcGIS for Power BI Questions https://community.esri.com/t5/arcgis-for-power-bi-questions/powerbi-map-bugs/m-p/731573#M18 <HTML><HEAD></HEAD><BODY><P>I have a user reporting a similar issue.&nbsp;&nbsp;Here is the workflow described by my user:</P><P></P><OL style="margin-top: 0in;"><LI>In an Excel spreadsheet, we “Get &amp; Transform Data” &nbsp;from the Enterprise SDE&nbsp;</LI><LI>The Navigation query is <EM>= SDW{[Schema="CITY",Item="CIP_ALL_POINT"]}[Data]</EM><OL style="margin-top: 0in;"><LI>The reason why we use this dataset is because it contains Lat/Long coordinates that Power BI needs to position the features in the map</LI></OL></LI><LI>We do some additional cleaning up of the data within the Query Editor of Excel (renaming/reordering/removing columns)</LI><LI>Then we query this spreadsheet in Power BI and do additional minor cleanup of the data.</LI><LI>This query is refreshed through an excel macro that we run on a monthly basis that refreshes the queries in the spreadsheet</LI></OL><P></P><P>The&nbsp;symbology -- don't believe it is a heat map -- reverts back to the default whenever the user moves between tabs, and it happens both in PowerBI desktop and web.</P></BODY></HTML> Wed, 07 Aug 2019 18:29:47 GMT DeenaBowman 2019-08-07T18:29:47Z PowerBI map bugs? https://community.esri.com/t5/arcgis-for-power-bi-questions/powerbi-map-bugs/m-p/731572#M17 <HTML><HEAD></HEAD><BODY><P>The ESRI PowerBI map is no longer zooming to the extent of the features that are plotted.&nbsp; Also, when I change a map to the "heatmap" theme, it does not save and reverts back to the original theme if go to a new tab and come back. This is happening in both PowerBI desktop and web.</P><P></P><P>Was there an update recently?</P></BODY></HTML> Wed, 07 Aug 2019 14:35:02 GMT https://community.esri.com/t5/arcgis-for-power-bi-questions/powerbi-map-bugs/m-p/731572#M17 EricO_Neal1 2019-08-07T14:35:02Z Re: PowerBI map bugs? https://community.esri.com/t5/arcgis-for-power-bi-questions/powerbi-map-bugs/m-p/731573#M18 <HTML><HEAD></HEAD><BODY><P>I have a user reporting a similar issue.&nbsp;&nbsp;Here is the workflow described by my user:</P><P></P><OL style="margin-top: 0in;"><LI>In an Excel spreadsheet, we “Get &amp; Transform Data” &nbsp;from the Enterprise SDE&nbsp;</LI><LI>The Navigation query is <EM>= SDW{[Schema="CITY",Item="CIP_ALL_POINT"]}[Data]</EM><OL style="margin-top: 0in;"><LI>The reason why we use this dataset is because it contains Lat/Long coordinates that Power BI needs to position the features in the map</LI></OL></LI><LI>We do some additional cleaning up of the data within the Query Editor of Excel (renaming/reordering/removing columns)</LI><LI>Then we query this spreadsheet in Power BI and do additional minor cleanup of the data.</LI><LI>This query is refreshed through an excel macro that we run on a monthly basis that refreshes the queries in the spreadsheet</LI></OL><P></P><P>The&nbsp;symbology -- don't believe it is a heat map -- reverts back to the default whenever the user moves between tabs, and it happens both in PowerBI desktop and web.</P></BODY></HTML> Wed, 07 Aug 2019 18:29:47 GMT https://community.esri.com/t5/arcgis-for-power-bi-questions/powerbi-map-bugs/m-p/731573#M18 DeenaBowman 2019-08-07T18:29:47Z