Hi friends,
I´m trying to connect Power BI with UiPath Orchestrator.
I have trying to follow these two links
First step
And the this
Second step
But i dont get it to work.
In both these Tutorials they refer to Orchestrator Reference, this page does not exist any more.
Where to finde the correct information?
In the new way the api interaction is different it uses external applications …go to admin-> external Applications → Create a new app and then get client id and secret which can be used to authenticate the api
cheers
Thanks @Anil_G,
I will try this. Do you know how i can get the logmessages out from the API. I cant find it in the documentation.
You can get them using robot logs…for more info on the endpoint and how to use…you can refer to the swagger file
/swagger/index.html` - this link will take you to the swagger.Please replace with your orchestrator url
Cheers
Hi @Anil_G
I need your support.
I have now created a External application in Orchestrator.
When i try to use it in my Power BI model i do get any token back.
What can be wrong?
Yes. But after you have created an External applications.
Would the next step to add my external app to a tentant?
Then next step would be to test on postman to check if you are getting response
If you are getting then in powerbi tenant you can add the auth
Cheers
@Anil_G
Thanks for the help on the way.
Now i solved the first part. But now there is another issue.
When you get the RobotLogs you wil only recive 1000 rows. This is a problem for me when i have 5000 rows.
Do you have any ide for me to solve that?
You hvae pagenation option(skip)…use that in the api and get the next 1000 records and so on
Cheers
But then i need to do that manually to switch the number with the skip command. I want it to get all of the data from Orchestrator auto and fill my table in Power BI.
But i have another thought, can i feed a sql data base and store the data there?
Then i can filter on the date as well.
Hi, Can you please elaborate on this?
