Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Refreshing data takes ages when Datasource (Excel file) is located in a shared folder

Dear sirs,

 

I have an issue with a map visual (Bing Maps), where it is supposed to show zip codes on the map visual.

Whenever I open the .pbix file, it takes ages for me to load the zip codes on the map. I have found out that the problem most likely is the data source. The Excel files filepath is within a shared folder, in which the pbix file also is located. If I have both files stored locally, there is no issues with loading the files.

 

The amount of locations does not exceed 3500, whereas the problem isn't that it cannot load all locations due to restrictions.

 

Am I the only one having these issues, or is it possible to fix it?

 

Thank you in advance 🙂

2 REPLIES 2
Greg_Deckler
Super User
Super User

Map visuals can be slow because basically it requires a geo-coding call to Bing maps for each location. That's generally the issue with map visuals being slow.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hi again,

 

Thank you for your answer. I forgot that I said it was taking ages. Problem is also that it stops loading the locations. Whenever i refresh I might get 20 more locations, but then have to refresh again and again and again to get the full map. I don't know if this is a common problem, but I stumble upon it from time to time.

 

Is this also "standard"? 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors