英文:
Power BI accessing blob storage, files headers are not there
问题
以下是已翻译的内容:
我是一个初学者,所以任何建议都很有帮助。我使用Azure Synapse Analytics从API获取信息,并将其保存为我的Blob存储中的文件。在使用在线Web应用程序时,文件确实有标题,但当我将Power BI连接到我的Blob存储并访问文件时,却没有标题。
我进入了管道并确保文件保存时选择了“第一行作为标题”,但这对我的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.
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.
答案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/
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论