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"
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?
This is absolutely brilliant - I've been looking for how to do this for the longest time.
Loop in PQ is awesome. Thanks for knowledge sharing.
This is a higher level of PQ! :)
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"
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!.
yes it can totally work for webservices!
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?
its possible in VBA