Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm currently accessing info from PeopleHR via API and getting the mentioned error.
I've created a new API key, done the queries from scratch, tried applying no transformation other than what is required to return results.
Data is loading in to the power query editor fine. I just can't close and apply it without the error.
Any help would be apprciated.
Solved! Go to Solution.
@TommyWommy
In your code, it expects a list but "" is supplied, you need to handle the exception in this case. Decide what should happen if your API doesn't return the expected result and how to handle the "" it blank.
you can use "try [your code] otherwise" option
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@TommyWommy
In your code, it expects a list but "" is supplied, you need to handle the exception in this case. Decide what should happen if your API doesn't return the expected result and how to handle the "" it blank.
you can use "try [your code] otherwise" option
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |