make sure to use the correct syntax for that either "&username=myuser&password=mypassword" or "&username=myuser&passhash=hash" (hash can be found in your account user) instead of "&apitoken=myapitoken" - and review the API call to ensure it is pointing to the correct info without typos example: 127.0.0.1/api/table.csv?content=devices&output=csvtable&columns=objid,probe,group,device,host,downsens,partialdownsens,downacksens,upsens,warnsens,pausedsens,unusualsens,undefinedsens,tags&count=*&username=myuser&passhash=hash
@@fingerprintinit finally got it but now I am getting this error when i try to get data from the web: Details: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
@@phindiwebambata3883 Your prtg web page needs to have a valid ssl certificate if it's using https. The video used here has prtg using http instead so that's why this error is not present for the video. I had to use a valid certificate for the page with https for power bi to accept it. Paessler has "PRTG Certificate Importer" tool to fix your problem, you will need a valide certificate to use.
![Summer Walker - Heart Of A Woman [Official Lyric Video]](http://i.ytimg.com/vi/SFddctbZzw8/mqdefault.jpg)
Hi There, Thanks a mil for this video it helped a lot. Could you do one for historic data api call?
Quick question I used my username, but it keeps giving me an error : 'Unauthorized"
make sure to use the correct syntax for that either "&username=myuser&password=mypassword" or "&username=myuser&passhash=hash" (hash can be found in your account user) instead of "&apitoken=myapitoken" - and review the API call to ensure it is pointing to the correct info without typos
example: 127.0.0.1/api/table.csv?content=devices&output=csvtable&columns=objid,probe,group,device,host,downsens,partialdownsens,downacksens,upsens,warnsens,pausedsens,unusualsens,undefinedsens,tags&count=*&username=myuser&passhash=hash
@@fingerprintinit finally got it but now I am getting this error when i try to get data from the web: Details: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
@@phindiwebambata3883 Your prtg web page needs to have a valid ssl certificate if it's using https. The video used here has prtg using http instead so that's why this error is not present for the video. I had to use a valid certificate for the page with https for power bi to accept it. Paessler has "PRTG Certificate Importer" tool to fix your problem, you will need a valide certificate to use.