Power BI 访问 blob 存储,文件头部丢失。

huangapple go评论78阅读模式
英文:

Power BI accessing blob storage, files headers are not there

问题

以下是已翻译的内容:

我是一个初学者,所以任何建议都很有帮助。我使用Azure Synapse Analytics从API获取信息,并将其保存为我的Blob存储中的文件。在使用在线Web应用程序时,文件确实有标题,但当我将Power BI连接到我的Blob存储并访问文件时,却没有标题。

Azure Synapse Analytics

PowerBI访问相同的文件

我进入了管道并确保文件保存时选择了“第一行作为标题”,但这对我的Power BI查询没有产生影响。

已选中“第一行作为标题”选项

英文:

I am a beginner in this so any advice is helpful. I used azure synapse analytics to get information from an API and save this as files in my blob storage. When using the online web application, the files do have headers however when I connect my Power BI to my blob storage and accessing the file on that, there are no headers.

Azure Synapse Analytics

PowerBI Accessing same file

I went into the pipeline and made sure the files are saving with "First row as header" and that didn't make an effect on my power BI query.

First row as header option ticked

答案1

得分: 1

你有很多列吗?

你可以通过编辑查询在Power BI中手动命名列。双击列名或从"Transform"选项卡中选择"重命名"。

如果你有很多列,那可能需要很多工作。

你希望文件的头部作为表格中的第一行出现。尝试取消选择"第一行作为标题",然后在获取数据源后,转到"转换数据"并选择"使用第一行作为标题"。

https://pbivisuals.com/2021/03/20/how-to-use-first-row-as-headers-in-power-query/

英文:

Do you have many columns?

You can manually name columns in Power BI by editing the query. Double-click on the column name or select "Rename" from the Transform tab.

If you do have lots of columns that is probably a lot of work.

You want the files to come through with the headers as the first row in the table. Try unselecting "first row of headers" and then once you have your data source, go to transform data and select "Use first row as headers".

https://pbivisuals.com/2021/03/20/how-to-use-first-row-as-headers-in-power-query/

huangapple
  • 本文由 发表于 2023年5月10日 17:15:24
  • 转载请务必保留本文链接:https://go.coder-hub.com/76216735.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定