Forum Discussion
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!
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
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.
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.
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.
