Forum Discussion
how to update query when the source data changes
Thanks! Lorenzo
You may want check the file attached I've added extra explanation with screen shots, I've also added the code ( but I am not allowed to share the API)
Many thanks!
I carefully looked at your query. No suprise, everthing is hard-coded (field names) when it comes to record's expansion, hence your problem. In a nutshell you have to make everything dynamic and that's not something easy when you're not familiar with https://docs.microsoft.com/en-us/powerquery-m/ (PQ language)
Also, you deal with a JSON document where a record/list/table can have nested records/lists/tables, each of them can have nested records/lists/tables... Expanding all is a serious challenge - to give you a sense have a look to ImkeF's function https://www.thebiccountant.com/2018/06/17/automatically-expand-all-fields-from-a-json-document-in-power-bi-and-power-query/ (I don't think her function can help you though)
Realistically speaking I don't see how someone can help without a bit of understanding on how the application (FULCRUM) works (re. records and the like it creates) and without an API key. I'm afraid I can't help you further with this but hope the above explainations will help you in a way or another
- thanks, L Z.
looks like the solution is to generate a new API token then replace it with the one in the Query advanced editor