Forum Discussion

juliensirop's avatar
juliensirop
New Member
8 years ago

How to get data from an hyperlink which is not a Web Site

Hi,   I'm getting UPS data by email on daily basis with a link in it. Clicking on the link triggers an Excel Spreadsheet Download, and I would like Power BI to pull this data itself.   I already ...
  • juliensirop's avatar
    juliensirop
    New Member
    8 years ago

    Hi v-chuncz-msft,

     

    Thank you very much for getting back to me.

     

    Could you please explain to me how to use this function in my specific case? I had a look on the internet but couldn't figure out how to use it ... All I can get is this:

     

     

    Thanks,

    Julien

    • fenixen's avatar
      fenixen
      Icon for Advocate II rankAdvocate II
      7 years ago

      Did you figure it out?  I have the same issue trying to open a csv file from a web page url.. 


      I have this URL (requires authentication, but i want to show how the URL looks)   https://"myCompany"/_/service/no.company.placeholder/read-and-acknowledged?id=7fc4c347-a074-44e3-b257-1627d763492c

       

      If I openthe URL in Chrome it downloads a .csv file. I cannot figure out why power BI can't do the same? It authenticates just fine, but returns the message cannot be retrieved using web.page. It doesn't appear to be a web page

       

      If i change it to .csv i only get this picture, its the code of the page, not the csv file. 

      • Mr_Glister's avatar
        Mr_Glister
        Icon for Advocate II rankAdvocate II
        7 years ago

        I have the same issue. Following the thread.