Power BI 和 JSON 数据 [英] Power BI and JSON data

问题描述

是否可以让 Power BI 读取 JSON 数据?我昨天花了一整天的时间来弄清楚如何在 Power Bi 中将 JSON 数据转换为可读的表格，但没有运气.

Is it possible to make Power BI read JSON data? I've spent an entire day yesterday to figure out how to convert the JSON data into a readable table in Power Bi, but with no luck.

我用谷歌搜索了几个小时，但没有任何合适的文档.

I tried googling for hours, but there is no proper documentation anywhere.

我正在从我的网站检索 JSON 有效负载，当我尝试导入时，它会显示如下数据:

I'm retrieving a JSON payload from my website and when I try to import, it shows the data like this:

Record
Record
Record
Record

也许我可以学习任何教程?或者可能是 Power BI 的另一种替代方案，可以正确读取和构造我的 JSON 数据?

Maybe there are any tutorials I can follow? Or perhaps another alternative to Power BI that would properly read and structure my JSON data?

推荐答案

正如评论中提到的，除了每个Record(如果是headers)，你能看到任何带有两个箭头的小框，尝试点击它.

As mentioned in comments, just besides each Record (if headers), are you able to see any small box with two arrows, try clicking it.

这篇关于Power BI 和 JSON 数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！