Forum Discussion

Regular Visitor

4 years ago

Solved

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 t...

Need Help

ImkeF
4 years ago
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

ImkeF

Community Champion

4 years ago

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

Forum Discussion

Create multiple Query from list [API]

Related content

Power Query - create multiple rows

Creating multiple Audiences in PowerBI App

Merging Multiple Queries

Multiple messages when new item created

Power Query Combine Multiple Files From Folder