Forum Discussion
Cannot Expand Null List
Well, that was it! Finally got it to load. Thanks for the help Greg_Deckler . Even though that wasn't the answer it was the only thing that allowed me to find the issue! Thanks!
Thanks Greg_Deckler, I've been having issues even telling whether a list is null since it's nested. I'm fairly new to dax though, so I may be doing something wrong. It's been difficult to track down the issue since it only occurs when I try to load it in the report. It's strange that it works fine in the editor.
Oh, this is not DAX, this is Power Query and the error you are getting is a Power Query error during data load. It is likely not happening while you are in the editor because the first rows do not exhibit a null but later rows do. Let me see if I can get you an example.