Forum Discussion

troygraham's avatar
troygraham
Frequent Visitor
9 years ago

API Post / Get & make into a http link

Our company is currently using Goformz and would like to start tapping into the backend using API Post and GET commands in Power BI so we can generate some report data for use in Excel.    I am ver...
troygraham's avatar
troygraham
Frequent Visitor
9 years ago

Hi Phil,

 

Thanks for your fast reply, but because I am still learning I found this very hard to follow and/or use same methods for my project.

 

If you could lead me to any simpler examples that may help, would be great.

 

Is it possible to setup an M Query ? and how would i apply it to my project needs. 

 

Cheers

 

Troy

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi troygraham

 

While it's probably not Advanced M, it's definitely not simple M either.  You are going to have to mix REST API knowledge with the M texted editor to achieve this one I'm afraid.

  • troygraham's avatar
    troygraham
    Frequent Visitor
    9 years ago

    ok i will have to keep digging for the answer.

     

    Another question and I am sure this is an easy one.

     

    Is there a way that i can add a textbox and button in excel to have the ability to change the highlighted text in the JSON Web Query and use the button to apply and refresh the sheet that the query is attached to ?

     

    JSON Query