Power BI Custom Connector using Power Query SDK in Visual Studio for RESTful API
Budget: $750 – $1,500 CAD
Hello,
Looking for some help creating a custom connector (.mez) file for Power BI. I can't share the details of the RESTful API yet, but essentially we'll need to do 4 seperate API calls, return the data in JSON, and reformat for Power BI to use. The API calls are all to the same base URL and authentication is simply by API key. The first call returns a list of unique IDs, whereby the unique IDs are then used in the second call, and so on, until all the data is returned for that API key. We need to send a 'start' and 'end' data parameter as well specified by the user making the request. Finally, there are limits on the number of rows that can be returned, so it's important to consider that multiple calls will need to be made to return all the data.
If this is something that you feel comfortable doing, please reach out with any questions and we can setup a call to discuss further!
Thank you for your time.
Looking for some help creating a custom connector (.mez) file for Power BI. I can't share the details of the RESTful API yet, but essentially we'll need to do 4 seperate API calls, return the data in JSON, and reformat for Power BI to use. The API calls are all to the same base URL and authentication is simply by API key. The first call returns a list of unique IDs, whereby the unique IDs are then used in the second call, and so on, until all the data is returned for that API key. We need to send a 'start' and 'end' data parameter as well specified by the user making the request. Finally, there are limits on the number of rows that can be returned, so it's important to consider that multiple calls will need to be made to return all the data.
If this is something that you feel comfortable doing, please reach out with any questions and we can setup a call to discuss further!
Thank you for your time.