Flow Map

[Jolly123]

Hello,

I have about 50,000 rows of data that have an origin city state zip and destination city state zip for each row of data. I am trying to use the Flow Map to show the whole network for each row of data from its origin to destination, but it's taking forever to load the map, even with the cache button turned on under the Advanced setting.

I also tried summarizing the data to narrow it down to the unique origin & destination pair (so for example, if the data has 500 rows going from New York to Boston, it will be 1 row instead of 500 rows when I run the map (which cut down the data from 50,000 rows to about 4,000 rows), but it's still taking a long time to load.

Also, whenever I change to a different tab and go back to the same tab where I already loaded the map up previously, the map will still then takes time to load again.

Does anyone have any recommendation/suggestion for the map to load faster? or is there a different map that will do the same thing but work faster for data that has an Origin and Destination pair?

Thank you!

[v-lionel-msft · Accepted solution]

Hi @Jolly123 ,

Try to refer to the link.

Optimization guide for Power BI - Power BI | Microsoft Docs

If the configuration of your local computer is too poor, you can consider putting the data on the cloud server and using the Direct Query or Live Connection mode. In these two models, the queries are calculated in the data source.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.