Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
piearesquared
New Member

CrowdStrike data

I'm looking to build a Power BI dashboard for a number of different tools, one of which is CrowdStrike. For CrowdStrike data, I would like details such as Alert Name, Severity, Time and most importantly, who is currently assigned to the ticket (if anyone). I'm using the endpoint /alerts/queries/alerts/v2. I worked with CrowdStrike support and confirmed the "assigned_to_name" field is what we're looking for. However, the field only shows up if someone is assigned to it, if nobody is assigned, the field is not present (not even in the null state).

 

When testing, I assigned myself an alert, and the field shows up.. however, the rest of the alerts give an error, almost as if it doesn't know how to ingest the rest of the alerts now that the "assigned_to_name" field is now present.

 

Is there a way to get this field to always show up, even if nobody is assigned to it? Maybe a permanent column I can have this field/data populate in?

 

TIA

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

Read about the way Power Query can handle missing columns. Then design your query accordingly so it can work in both scenarios.

View solution in original post

3 REPLIES 3
piearesquared
New Member

Thank you. Any documents that can aid in this reading?

lbendlin
Super User
Super User

Read about the way Power Query can handle missing columns. Then design your query accordingly so it can work in both scenarios.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Kudoed Authors