Forum Discussion
Resolver IUNABLE TO WORK WITH JSON FILE IN POWER QUERY EDITOR
There are a couple of transforms you can try
Binary.ToText - PowerQuery M | Microsoft Learn
Text.FromBinary - PowerQuery M | Microsoft Learn
Json.FromValue - PowerQuery M | Microsoft Learn
Be aware that transitioning from a hierarchical (NoSQL) to relational (table) environment requires you to make compromises in the way you flatten the hierarchy. You cannot expect this to be a 1:1 transition.
Super UserThere are a couple of transforms you can try
Binary.ToText - PowerQuery M | Microsoft Learn
Text.FromBinary - PowerQuery M | Microsoft Learn
Json.FromValue - PowerQuery M | Microsoft Learn
Be aware that transitioning from a hierarchical (NoSQL) to relational (table) environment requires you to make compromises in the way you flatten the hierarchy. You cannot expect this to be a 1:1 transition.