Forum Discussion

PhillipRothwell's avatar
PhillipRothwell
Frequent Visitor
7 years ago

Use CSV column as custom parameter

Hi I'm exploring the use of API to extract data for use in Power BI. Take the following as a particular call   https://mrurl.com/api/coursecode/33795/analytics/activity s I have a CSV containing ...
Tips and Tricks
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi PhillipRothwell ,

 

As Imkef suggested here, you should firstly load the CSV file into desktop as a query, that holds all the variables/parameter and add a custom column to it where you make your API call, thereby referencing the column(s) with your variables where needed. That will return a colum with all the values from the different rows of your table that you can simply expand. 

 

Best regards,

Yuliana Gu