Forum Discussion

Pk8524's avatar
Pk8524
Helper I
1 year ago
Solved

Image from website requiring login and password (windows security)

I am trying to get the image from a link more or less like this: 

https://myprofile.example.com/User%20Photos/Profile%20Pictures/PERSONNAME_LThumb.jpg

When I open this in web browser:

 

After typing login and password, the image of a person appears. I can generate the list of links based on person name but is it possible to somehow import them to powerbi?

Need Help
  • jaineshp's avatar
    jaineshp
    1 year ago

    Hey Pk8524,

    Looking at your screenshot, this is a classic authentication challenge in Power BI. Here are a few approaches to try:

    Option 1: Web Connector with Credentials

    • Use Get Data > Web
    • Enter one of your URLs
    • When prompted, choose "Windows" authentication
    • Enter your domain credentials
    • If it works for one image, you can modify the M code to loop through your name list

    Option 2: Pre-download Approach

    • Write a simple PowerShell script to download all images using your credentials
    • Save them to a local/SharePoint folder
    • Import from there into Power BI (much more reliable)

     

    Try the Web connector approach with just one URL first. If Power BI can't handle the auth popup, the pre-download method is usually your best bet.

    The authentication popup you're seeing typically means Power BI will struggle with direct connections. Most folks in similar situations end up going with Option 2.

     

    Fixed? ✓ Mark it • Share it • Help others!


    Best Regards,
    Jainesh Poojara | Power BI Developer

3 Replies

  • v-karpurapud's avatar
    v-karpurapud
    Community Support
    1 year ago

    Hi Pk8524 

    Thank you for posting your question on the Microsoft Fabric Community Forum, and thanks as well jaineshp   for the ongoing support and assistance.

     

    Could you let us know if the suggested solution resolved your issue? This information can assist other community members facing similar challenges.

    Thank you.

     

    • jaineshp's avatar
      jaineshp
      Memorable Member
      1 year ago

      v-karpurapud,

      Thank you for the kind recognition - always happy to contribute to our community's success!

      Best Regards,
      Jainesh Poojara | Power BI Developer

  • jaineshp's avatar
    jaineshp
    Memorable Member
    1 year ago

    Hey Pk8524,

    Looking at your screenshot, this is a classic authentication challenge in Power BI. Here are a few approaches to try:

    Option 1: Web Connector with Credentials

    • Use Get Data > Web
    • Enter one of your URLs
    • When prompted, choose "Windows" authentication
    • Enter your domain credentials
    • If it works for one image, you can modify the M code to loop through your name list

    Option 2: Pre-download Approach

    • Write a simple PowerShell script to download all images using your credentials
    • Save them to a local/SharePoint folder
    • Import from there into Power BI (much more reliable)

     

    Try the Web connector approach with just one URL first. If Power BI can't handle the auth popup, the pre-download method is usually your best bet.

    The authentication popup you're seeing typically means Power BI will struggle with direct connections. Most folks in similar situations end up going with Option 2.

     

    Fixed? ✓ Mark it • Share it • Help others!


    Best Regards,
    Jainesh Poojara | Power BI Developer