Import data from web as logged in user

[webportal]

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!

[Greg_Deckler]

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]

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 · Accepted solution]

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.