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
Juliecal73
Helper III
Helper III

outlook.office365.com Refreshes Very Slowly

Hi,

I have a table of usernames (~15000) and for each one I build out a Image url using Web.contents to access their Profile pictures in Power Query Editor.

This works great, but when I refresh, it is now taking a couple of hours because it is extremely slow at accessing outlook.office365.com to build each of the Image urls.

 

Juliecal73_0-1610749110768.png

All the other data sources (SQL) refresh fine.

Does anyone know why it takes so long? Is there perhaps a better way of doing this?

4 REPLIES 4
Juliecal73
Helper III
Helper III

I am still struggling with this...

 

I actually only need about 300 of the Image URLs as this is who is currently active in this geographical area, but was hoping to have this dynamic so that if a new person became active in this area, we would see their image.

So the scenario becomes this:

 

I have Table 1 (SQL) which is a list of Names (~300)

I have Table 2 (https://outlook.office365.com/) to get the email addresses of everyone in the organization (~15000).

 

How can I do a merge of these tables, keeping only the Table 1 data but with their Table 2 emails (~300 records) and then after that use Web.Content to get their Profile Images from O365?

 

Juliecal73_12-1611681406749.png

This currently fails with the error about accessing other queries before the Web.Content call.

 

Juliecal73_0-1611680813997.png

 

Juliecal73_2-1611680872041.png

 

Juliecal73_1-1611680846056.png

 

Can I filter Table 2 by Table 1 in Power Query, do the Web.Content step (much quicker for ~300) and then Merge them?

Juliecal73
Helper III
Helper III

Any thoughts on this please?

parry2k
Super User
Super User

@Juliecal73 you are not loading pictures in the model, you are just creating URL, correct?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi, that is correct, at least that is what I belive. I use the email address in the following code to get the unique image URL for each user from OL and load it in the table.

Web.Contents("https://outlook.office365.com", [RelativePath="/ews/Exchange.asmx/s/GetUserPhoto", Query=[email=[organizationalPerson.mail], size="HR120x120"]])

Juliecal73_1-1610980782151.png

 Juliecal73_0-1610980680010.png

Then I mark it as an Image URL type and it displays the profile images in a table visual.

The process of updating this table (only 5 olumns) now takes hours when it used to take minutes.

Previously I was doing it on a table with only about 150 records, and that took a while, but not bad.

But now with 15000 records...

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.