Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Heatmap data

  • 1.  Heatmap data

    Bronze Contributor
    Posted May 15, 2019 04:39 PM
    Hi,

    I'm trying to create a heat map of locations from an excel spreadsheet(5899 records) using "Heat Map" visual, but it's only displaying 3791 records. Is there a limit, how do I get this to display all the data.

    ------------------------------
    Geethika
    ------------------------------


  • 2.  RE: Heatmap data

    Top Contributor
    Posted May 15, 2019 10:54 PM
    Hi,

    Please cross check if all 5899 rows get loaded into Power BI.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------



  • 3.  RE: Heatmap data

    Silver Contributor
    Posted May 16, 2019 10:09 AM
    Hi Geethika - If it is a data limitation, we have used this one and the developer increased the limit to the Power BI max so it would work for us.

    https://github.com/sjkp/heatmap/releases/tag/5.0.0

    ------------------------------
    Holly Kramer
    Digital Design Application Specialist
    Interior Architects
    Houston TX
    713-481-3161
    ------------------------------



  • 4.  RE: Heatmap data

    Bronze Contributor
    Posted May 16, 2019 11:25 AM
    I'm not exactly sure if the issue is record limit, I'll give this a try and see if it fixes it.

    Thanks!

    ------------------------------
    Geethika
    ------------------------------



  • 5.  RE: Heatmap data

    Bronze Contributor
    Posted May 16, 2019 11:17 AM
    Edited by Geethika L May 16, 2019 11:25 AM
    Yes, all the data got loaded.

    Thanks,
    Geethika L

    Original Message:
    Sent: May 15, 2019 10:53 PM
    From: Hasham Bin Niaz
    Subject: Heatmap data

    Hi,

    Please cross check if all 5899 rows get loaded into Power BI.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan