Hi, I am facing an issue while fetching the API data to Power BI. Actually, I have got a requirement from the client and they have provided JSON data through API, I have tested that API in postman and generated an access token and passed that token in power bi but it's not working. Throwing pop messages like we can't connect this URL and below that there are few options like Retry, edit and cancel. But this is the method to connect APIs to Power BI to load the data. How can we solve this problem?.Kindly help out on this.
Hi, I've got the exact same problem previously, took some time and luck to find out. Microsoft should change the error message to a more meaningful one.
Hey, I am trying to hit dataflow transactions power bi rest api using power automate flow using service principal but I'm getting unautorized as error and detailed error is serviceprincipalisnotallowedbytenantadminswitch .... Can you plz let me know what access permissions do we need for service principal to hit tha api without any error .. thanks
Hi try to take dynamic token from powerbi desktop it showing bad request 400. if take manually token cand copy it is working fine. can you please help me on this if you have any code please send to me . thanks!!
Get More than 90 Days Audit Log: ruclips.net/video/trBo-Ghf9qE/видео.html
Hi, I am facing an issue while fetching the API data to Power BI. Actually, I have got a requirement from the client and they have provided JSON data through API, I have tested that API in postman and generated an access token and passed that token in power bi but it's not working. Throwing pop messages like we can't connect this URL and below that there are few options like Retry, edit and cancel. But this is the method to connect APIs to Power BI to load the data. How can we solve this problem?.Kindly help out on this.
Hi, I've got the exact same problem previously, took some time and luck to find out. Microsoft should change the error message to a more meaningful one.
Hey, I am trying to hit dataflow transactions power bi rest api using power automate flow using service principal but I'm getting unautorized as error and detailed error is serviceprincipalisnotallowedbytenantadminswitch .... Can you plz let me know what access permissions do we need for service principal to hit tha api without any error .. thanks
hey I am getting the same error and I have been struggling to get an answer to this for a long now. Please let me know if you found one.
Hi try to take dynamic token from powerbi desktop it showing bad request 400. if take manually token cand copy it is working fine. can you please help me on this if you have any code please send to me . thanks!!
How can I get data from rest-api using self-signed certificated with beer authorization?
I believe someone from your Data Platform or networking team can help you with this.
@@BIConsultingPro Thank for answer. I'm from infra team and I resolved this issue.
Hello Sir
Please help me on how to write back session id
Could you please elaborate a bit more? What is the problem statement and your expected result.
can you please make video on how to use Power BI Rest api using python script
Yes, we have already created one. Please watch this video: ruclips.net/video/bwiD-nCSKvc/видео.html
How shedule refresh thr api
You'll get all the information on Power BI API page.learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset