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.
Hi All,
I have data in different pages like:
Page01:https://abccccccc.teamwork.com/projects.json/page=1
Page02:https://abccccccc..teamwork.com/projects.json/page=2........
..
..
Page15:https://abccccccc..teamwork.com/projects.json/page=15
How to load data in Power bi all apis at a time.
Thanks,
Pratima
Hi @Pratima,
One workaround is listing all the page URLs in a single column like below.
Then, add a custome column to load data from these pages.
Click to expand to the table, you will get all available data in a single query.
However, the limitation for this workaround is that we are not able to refesh data after publishing to service.
So, another option to work around your requirement is writing external procedure to load data from all APIs into a file or database, then, in Power BI desktop, you can directly connect to the file or database to fetch data at a time.
Best regards,
Yuliana Gu
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |