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

问题描述

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

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(如果有标题)之外，您是否还可以看到带有两个箭头的小框，请尝试单击它.

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屋！