Power Query - Looping and API Calls!

Поділитися
Вставка
  • Опубліковано 24 гру 2024

КОМЕНТАРІ • 8

  • @neils9565
    @neils9565 Рік тому +3

    This is absolutely brilliant - I've been looking for how to do this for the longest time.

  • @KhajonsakLun
    @KhajonsakLun Рік тому +1

    Loop in PQ is awesome. Thanks for knowledge sharing.

  • @juja2819
    @juja2819 Рік тому +1

    This is a higher level of PQ! :)

  • @franp209
    @franp209 Рік тому

    Grate video! was just what I was looking for in a personal proyect. I'm having a problem nad I wanted to see if you could point me out the error, it's really weird. I create a function of the same style in PBI desktop and it works grate, but when i take it to a data flow on the web i get this error " One or more tables reference to a dynamic data source"

  • @andyelgohary13
    @andyelgohary13 Рік тому

    Will this loop works in Web Services, I am trying to figure out how to create a loop that works when I publish my reports!.

    • @basensei8699
      @basensei8699  Рік тому

      yes it can totally work for webservices!

  • @ItsWithinYou
    @ItsWithinYou 8 місяців тому

    I need to connect to API. For connection, there are 2 parameters - client id and password. Once enter the values of these 2 parameters, we get a token to access the api. This token is valid for 60 minutes so if the report is going to refresh again after 60 mins, it has to run this process again and generate a new security token. After accessing api, I need to input values from a column (from an existing table in power bi report) and api will give me rate value (in integer format) for each of these values. I need to save these rate values in a new column in an existing power bi table. Can you please provide guideline on how to accomplish this?

    • @den8423
      @den8423 7 місяців тому

      its possible in VBA