Forum Discussion
Create multiple Query from list [API]
Hello
I use an API rest that comes to load the data with as parameter a code that I get from another API.
Today, I manually modify the name of the parameter (presented as a list) to generate a table. Example here with the object_type from the list
What I want to do is to create from the list as many queries as different code present in the list
This is to avoid changing manually each code and to have directly a table by code
Thanking you in advance for your help.
Hi Inspirable ,
Sources like this usually don't belong into different tables in the data model.
Have you considered to create one table with a column containing the source instead?
These blogposts describe how to achieve:
Web Scraping 1: Combine multiple tables from one page in Power BI and Power Query – The BIccountant
Web Scraping 2: Scrape multiple pages at once and refresh in Power BI service – The BIccountant
1 Reply
- ImkeFCommunity Champion
Hi Inspirable ,
Sources like this usually don't belong into different tables in the data model.
Have you considered to create one table with a column containing the source instead?
These blogposts describe how to achieve:
Web Scraping 1: Combine multiple tables from one page in Power BI and Power Query – The BIccountant
Web Scraping 2: Scrape multiple pages at once and refresh in Power BI service – The BIccountant