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.
Hi everyone,
Our company uses the application Dyflexis for scheduling the employees. They have an API available and I have access to it with my API token. When I want to add a new data source to my dashboard as 'web' and I fill in the api link and my token, I can't connect because it gives me a message 'A web API key can only be sepcified when a web API key name is provided.
Can someone help my connect to the API? I have no idea what to do or try..
Thank you,
Tim
Hi,
Not sure if you are open for 3rd party driver but ZappySys has very easy to use ODBC Drivers for REST API which can connect to any APi and it has many Pagination / Authentication options.
You can write queries like below
SELECT * FROM $ LIMIT 25 WITH( src='https://wordpress.org/news/wp-json/wp/v2/categories?per_page=10' ,PagingMode='ByResponseHeaderRfc5988' ,WaitTimeMs='200' --//wait 200 ms after each request )
Here is an article you can start with.
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
Check below link for more articles reklated to Power BI and Rest API Integration.
https://zappysys.com/blog/category/odbc-powerpack/odbc-app-integration/bi-reporting-power-bi/
@Rapportage,
Which authentication method do you use in Access web content dialog? Since you have filled in the api link with your token, please choose Anonymous authentication and check if you get any error message.
Regards,
Lydia
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.