WOW! Your content is amazing and genuinely helpful in practical applications, not just the regular tutorials with almost the same stuff. I really liked this series!!
Dudeeee - thanks for posting! I got this idea myself to avoid the PowerBI 'premium' API limitation and get data out of the reporting model and you just verified it's possible!
Actually ended up taking a different approach, figured out how to decode data from a power bi service dashboard tile without needing a premium subscription.
This is amazing thank you so much, I've been looking for a few days for exactly this, you should put in the title or the description that you are posting from excel cells, since most of the other tutorials don't, they post content from the Power Query lines of code which is sort of useless (you can do that in many other meaningful ways)
This may be useful to some. Content=Text.ToBinary("grant_type=client_credentials") Now i just need to think of a way to get a new token when the current one expires
@@florianpieront3296 if you are asking about checking if the token has expired or not, i don't think it will work on excel as every time when the token expired, excel will pop up a screen saying unable to authenticate. "Try and otherwise" doesn't bypass this pop up. My solution was to try if the token allow me to run the api, if yes, return the original token, otherwise get a new token. The source will be the excel table output from this query, thus it will be a loop.
@@florianpieront3296 another way is to add a new column for the timestamp of when the token is received. Then use this excel table as the source to do a loop. Let's say your token expires every 2 hours, your query will be if timestamp is less than current time-2hrs, then get a new token and timestamp, else return the source.
Hi ,great video! One question, how to define in coding the following (in postman is including on the body part) as it is need for the post call ?{ "ResultType": "Hierachical", "FilterConditions": [ { "EntityName": null, "Filter": null, "Sort": null } ], "PageNumber": 1, "PageSize": 25, "ProjectionOnly": false, "Parameters": {} }
Thank you for a great video! However, When copying you code (really step-by-step) I'm getting a Formula.Firewall error for MakePostRequest (step 'Source'). Any thoughts on why that may be?
Hi, Thanks for the video. Would it be possible to do a post request using the salesforce connector (no url), and change a field based on another query with an unique key in found in both tables ? Most likely with an inner merge... Edit: I don't understand where the column of the key, name of the key and value I want to replace are :(
Thanks for the video - i was able to replicate and it works for my purposes. One question though - I need to be able to post an array of lists of records (relevant step at 10:55), where you add in {0} to get the first values out of the list. Can you please help? I am learning through a LOT of trial and error (mostly error haha).... any assistance would be extremely appreciated. Thank you again!
Awesome video! It helps me a lot.. Now can you please tell me how I can post multiple numbers of 'Access_Token'...? Here you have showed only one...will it be comma separated..? like...'12345678', '154789632', ' 1215468963'......like this..?
WOW! Your content is amazing and genuinely helpful in practical applications, not just the regular tutorials with almost the same stuff.
I really liked this series!!
Dudeeee - thanks for posting!
I got this idea myself to avoid the PowerBI 'premium' API limitation and get data out of the reporting model and you just verified it's possible!
did you manage to do it ?
Actually ended up taking a different approach, figured out how to decode data from a power bi service dashboard tile without needing a premium subscription.
@@danbadenko Wow do you have a github repo for that ?
This is amazing thank you so much, I've been looking for a few days for exactly this, you should put in the title or the description that you are posting from excel cells, since most of the other tutorials don't, they post content from the Power Query lines of code which is sort of useless (you can do that in many other meaningful ways)
Thanks for the video.
You are welcome!
Thank you very much, just what I needed.
Thanks for the video. It really helps me.
This may be useful to some.
Content=Text.ToBinary("grant_type=client_credentials")
Now i just need to think of a way to get a new token when the current one expires
I like where you're going with this.
Do you have a solution already? I'm thinking I need to have a separate Azure Function to request a token first and store that one in a parameter.
@@florianpieront3296 if you are asking about checking if the token has expired or not, i don't think it will work on excel as every time when the token expired, excel will pop up a screen saying unable to authenticate. "Try and otherwise" doesn't bypass this pop up.
My solution was to try if the token allow me to run the api, if yes, return the original token, otherwise get a new token. The source will be the excel table output from this query, thus it will be a loop.
@@florianpieront3296 another way is to add a new column for the timestamp of when the token is received. Then use this excel table as the source to do a loop.
Let's say your token expires every 2 hours, your query will be if timestamp is less than current time-2hrs, then get a new token and timestamp, else return the source.
Hi ,great video! One question, how to define in coding the following (in postman is including on the body part) as it is need for the post call ?{
"ResultType": "Hierachical",
"FilterConditions": [
{
"EntityName": null,
"Filter": null,
"Sort": null
}
],
"PageNumber": 1,
"PageSize": 25,
"ProjectionOnly": false,
"Parameters": {}
}
Thank you for a great video! However, When copying you code (really step-by-step) I'm getting a Formula.Firewall error for MakePostRequest (step 'Source'). Any thoughts on why that may be?
Hi,
Thanks for the video. Would it be possible to do a post request using the salesforce connector (no url), and change a field based on another query with an unique key in found in both tables ? Most likely with an inner merge...
Edit: I don't understand where the column of the key, name of the key and value I want to replace are :(
Hey i have an api i want to send request 1 Guid in body have 1 url and have 1 header how can i do that
Thanks for the video - i was able to replicate and it works for my purposes. One question though - I need to be able to post an array of lists of records (relevant step at 10:55), where you add in {0} to get the first values out of the list. Can you please help? I am learning through a LOT of trial and error (mostly error haha).... any assistance would be extremely appreciated. Thank you again!
Awesome video! It helps me a lot.. Now can you please tell me how I can post multiple numbers of 'Access_Token'...? Here you have showed only one...will it be comma separated..? like...'12345678', '154789632', ' 1215468963'......like this..?