Forum Discussion

bi_small_potato's avatar
bi_small_potato
Frequent Visitor
1 year ago
Solved

Python Rest API Python 404 ExecuteQueries

I am using power bi rest api by python to get the table data using service principal. I had enable all the required settings under the tenant settings and able to get groups report through the api. H...
Need Help
bi_small_potato's avatar
bi_small_potato
Frequent Visitor
1 year ago

yes , i had actually replace all with my groupid and datasetid and grant the permission as admin for the workspace, i am able to get the result 'https://api.powerbi.com/v1.0/myorg/groups/{groupID}/datasets/when i search for dataset , but it dont work for executequeries , the dax queries is work in power bi as it is just simple evaluate values() .

tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

Is this option enabled in your tenant?

If you dont have permissions to reach tenant admin portal then you can run the same api with your user id and its token. If that works then its an issue this setting. Also have you verified the other limitations documented here  

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

Is there any RLS configured for your dataset? Please re validate all the limitations

 

Need a Power BI Consultation? Hire me on Upwork

 

 

 

Connect on LinkedIn

 

 

 








Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

 

  • bi_small_potato's avatar
    bi_small_potato
    Frequent Visitor
    1 year ago

    yes , i had enable these settings , and the dataset had no RLS .

    • tharunkumarRTK's avatar
      tharunkumarRTK
      Super User
      1 year ago

      bi_small_potato 

      That sounds odd. One quick question, your original post suggests that you ran requests.get function. 
      Should not it be requests.post method?

      Considering this the api documentation itself says its a post call

      https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries

       

      Need a Power BI Consultation? Hire me on Upwork

       

       

       

      Connect on LinkedIn

       

       

       








      Did I answer your question? Mark my post as a solution!
      If I helped you, click on the Thumbs Up to give Kudos.

      Proud to be a Super User!
      • bi_small_potato's avatar
        bi_small_potato
        Frequent Visitor
        1 year ago

        thanks , you are right. I had use wrong function , i need to use request.post instead of request.get , 😂