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.
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
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.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |