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