Forum Discussion

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
10 years ago
Solved

Import data from web as logged in user

Hello,

 

I'd like to import data from http://markets.ft.com/data/equities/tearsheet/financials?s=NVG:LIS&subview=IncomeStatement to Power BI Desktop.

 

As a user of ft.com I have access to 5 years of data, but when I try to import the data to Power BI Desktop, I'm not logged in to ft.com so I can only get 3 years.

 

Is it possible to import the page as a logged in user?

 

Thank you so much for helping!

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Yeah, its going to depend on what authentication that website supports. My best guesses are perhaps maybe Basic would get you there but it just depends on the web service.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Go to File | Options and Settings | Data Source Settings, click on the source and choose "Edit Permissions". Under Credentials, click on "Edit" and you have several options, Anonymous, Windows, Basic, Web API and Organizational account.

    • webportal's avatar
      webportal
      Icon for Impactful Individual rankImpactful Individual
      10 years ago

      Thanks a lot!

      That should solve the problem, however, after entering my credentials, I still don't get the 5 columns as I should being logged in.

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        10 years ago

        Yeah, its going to depend on what authentication that website supports. My best guesses are perhaps maybe Basic would get you there but it just depends on the web service.