Forum Discussion
Parse JSON Column with the Relational Key Value as an Attribute
Greetings all, Problem: I am currently attempting to ingest data into our Power BI ecosphere by building a dataflow connected to an Odata source. Connection is set up and functioning correctly...
Power Query does not take kindly to dynamic output column changes. You will be perpetually trapped in the "Evaluating..." issue of meta data updates. You need to unpivot your response data to avoid that.
That's what I was afraid of. I don't control the source, just consume from it. I'm going to have to dump to a local SQL db, re-model there (and probably just normalize into a small relational model anyway), then bring back to Power Query to build the report.
Thanks for your input.
BB