Ravneet –
I did hear back from Victory after sending this message to Ian earlier.
I believe she closed the ticket based on the information she gave and I followed.
Thanks for following up though.
~K
Original Message:
Sent: 2/27/2024 3:38:00 PM
From: Ravneet Kaur
Subject: RE: Connection with Power BI
Hey Kylie,
Thank you for bringing this to our attention, we will respond to this via the support ticket for tracking purposes and post a response back here with the solution once the issue is resolved. Thanks for your patience.
------------------------------
Ravneet Kaur
Customer Support Manager
TrueContext
Ottawa
------------------------------
Original Message:
Sent: 02-27-2024 13:42
From: Kylie Clarke
Subject: Connection with Power BI
Hi Ian -
Thanks for responding to this - I did sent you a DM thanking you. I was wondering if you might be able to help me. We set up connections to SP Lists based on your recommendation - 2 of the lists populate as expected, however 2 of them constantly receive this error message:
Send to your Microsoft SharePoint List account (Shop Daily to SP List) | Failed | Microsoft Graph API Error: invalidRequest -- One of the provided arguments is not acceptable. -- 9bcf6e55-cb8d-485d-b093-572e06c2a2b9 -- Fri Feb 23 16:49:42 UTC 2024 (ID ce8dd47c-a704-4a9d-9f20-63e2d9ae339f__5) | invalidRequest -- One of the provided arguments is not acceptable. -- 9bcf6e55-cb8d-485d-b093-572e06c2a2b9 -- Fri Feb 23 16:49:42 UTC 2024 |
I have a ticket open with support, but have not heard back from them in over a week. Anything you can provide that might give me some insight to this error would be greatly appreciated.
Thanks!
------------------------------
Kylie Clarke
Contracts Manager
Anderson Environmental Contracting
WA
Original Message:
Sent: 02-01-2024 08:51
From: Ian Chamberlain
Subject: Connection with Power BI
Hey Kylie!
Thank you so much for the question! Just wanted to touch on the API documentation, the correct docs for our API is going to be here: https://live.prontoforms.com/api-docs and the base API URL will still be listening at: https://api.prontoforms.com/api/1.1/
That is one of the things that we did not update to TrueContext because there are a lot of existing workflows built out there so we didn't want to break anything like that.
When it comes to PowerBI, I would personally suggest that you push your data into a Sharepoint List and point PowerBI at the list to report from there. I have actually written a community post about doing just that, it is a high level overview on this topic but should shed some light on the topic: https://community.truecontext.com/discussion/ians-insights-ep-9-microsoft-lists-and-powerbi-what-to-do-with-your-data#bm2b921673-5a2b-4b28-a161-e2bfb8019215
Using the Sharepoint List as a place for all your data makes the ingestion and formatting of the data a little easier than pushing the submissions through with our API. If you are already using a List or Document Library as a destination for your forms, you can even just point PowerBI to a Document Library and report off the Custom Metadata that is associated.
I am also curious as to which endpoint you were trying to use and were unsuccessful with in regards to our API.
I hope this helps and feel free to follow up with more details/questions!
Thank you
------------------------------
Ian Chamberlain
Solutions Architect
TrueContext
Original Message:
Sent: 01-31-2024 20:41
From: Kylie Clarke
Subject: Connection with Power BI
Hello -
We are setting up our connection between TC and Power BI using an API and are struggling somewhat with the support documentation.
Our live spaces live on the truecontext.com website, but the documentation on setting up the API all still points to prontoforms.com. We have tried both locations, without any luck.
Has anyone had any experience setting up their connection that you would share?
Many thanks!
------------------------------
Kylie Clarke
Contracts Manager
Anderson Environmental Contracting
WA
------------------------------