Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Was wondering if anyone has tried integrating celoxis with powerbi. I tried entering the api call string http://yourservername:portnumber/psa/api.do?function=login&username=username&password=password&company-code=companycode (and it returns the token via brower) in both web basic as a singular string and in advanced. However, it returns error 500 within powerbi. Anyone get any further?
Unfortunately I've been busy with other things. I'll try to find some time this week to keep working on this.
@felixpau,
What format of the URL do you enter in Power BI Desktop? After you get the token of your api, do you enter URLs like below in web connector of Power BI Desktop?
http://<celoxis-server-name>:<port>/psa/api.do?function=query&table=db_project&status_id=1&data-format=json&token=xxxxx&data-format=xml
http://<celoxis-server-name>:<port>/psa/api.do?function=query&table=db_task&id=100&token=xxxxxxxxxx&data-format=json
Reference:
https://celoxis.atlassian.net/wiki/spaces/DOC10/pages/73925306/Examples+of+XML+JSON+API
Regards,
Lydia
I tried entering this (with the server information and permanent token)
http://<celoxis-server-name>:<port>/psa/api.do?function=query&table=db_project&status_id=1&data-format=json&token=xxxxx&data-format=xml
returns a Server Error – Signature Missing from encrypted data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.