Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries