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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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.


@ 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!:
Mastering Power BI 2nd Edition

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.