You can send your Float data to the Power BI dashboard using the Float API.
Setting up an integration
To connect, you will need your Float API key. The Account Owner can locate the API key for your team in the Integrations tab within the Team settings.
In Power BI, open the Get Data > From Web > Advanced window and populate the URL parts and the HTTP request header parameters (optional) fields.
The URL starts with https://api.float.com/v3, and the authorization header value is Bearer + your API key.
Depending on the data you want to pull from Float, you can use different API calls. For more details, please check out our API documentation here.
💡 Here's a tip: You can connect other Microsoft tools like Excel or Power Automate in a similar way.
Keeping your data in sync with the Delete log
If you're using the Float API to sync data with Power BI or another BI tool, the Delete log can help you keep your data store accurate without running full re-syncs.
Once enabled, you can query the Delete log endpoints to find out which allocations, logged time records, or time offs have been deleted in Float in the last 72 hours.
This allows your sync scripts to remove those records from your BI data store directly, instead of polling all items and cross-referencing IDs.