Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |