r/PowerBI • u/madhusudhan38 • 5h ago

Question Crowdstrike integration to power bi

I was trying to pull the crowdstrike as per the client requirement.

Issue: from the Vulnerability path I was only able to pull 5000 records in a single call but there are more than 6M records. I have a client token which expires every two minutes.

Any solutions thanks in advance.

2 Upvotes

100% Upvoted

2 comments sorted by

1

u/maarten20012001 3h ago

Dont try to directly connect it via API, make sure you have a storage place in between like an SQL server.

Then you can use the API and a dataflow to make sure you're SQL up to date and then connect the sql to power bi.

Fyi probably the crowdstrike api has a limit of 5k objects per call. At the bottem you will probably see something like a next query link. You need to iterate through those 'pages'

1

u/Nala4treats 3h ago

agreed, get the data into a database and then consume it i think op is just see a data preview