Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Good day, I am trying to link to the Google Finance Data for GOOGLE:
(Get Data, Web)
https://www.google.com/finance?q=NASDAQ:GOOG&fstype=ii
However, this link is taking me to the quarterly data and income statement information
How can I change the path to link to the Annual Data of the Balance Sheet?
Thank you in advance
Solved! Go to Solution.
Hi @vrossouw,
The url which you used only shows the analysed and formatted data, current power query not support to operate the pages script(javascript functions in page) to switch the displayed data.
Logic:
1. Get data from google finance api with the inputted keywords.
2. Receive and analysis by javascript functions.
3. Cache these data to browser.
In my opinion, you should get data from google finance api to instead of the current url. Perhaps you can get more support at the forums which related to google finance api.
Regards,
Xiaoxin Sheng
Hi @vrossouw,
The url which you used only shows the analysed and formatted data, current power query not support to operate the pages script(javascript functions in page) to switch the displayed data.
Logic:
1. Get data from google finance api with the inputted keywords.
2. Receive and analysis by javascript functions.
3. Cache these data to browser.
In my opinion, you should get data from google finance api to instead of the current url. Perhaps you can get more support at the forums which related to google finance api.
Regards,
Xiaoxin Sheng
okay thank you
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 20 | |
| 19 | |
| 11 |
| User | Count |
|---|---|
| 65 | |
| 54 | |
| 46 | |
| 44 | |
| 31 |