Forum Discussion
D365 F&O Azure Data Lake - missing column headers
We have just moved our aggregate measures for D365 F&O to the Azure Data Lake. I beleive we have followed all steps in the guide (we have even done it a second time to be certain). All aggregate measures become available as expected and we can see them both in the storage account in Azure and in Power BI after connecting. The only problem is that all column headers in all tables have been replaced with "Column 1", "Column 2" etc. I guess we are missing some key step, but until now not clear on what it might be. Appreciate any guidance!
HI Anonymous
1. Could you please kindly share the guide you followed?
2. Is the column header available in the storage account in Azure?
From this article, "There are a couple of things to keep in mind when creating files for import. First, many files generated for big data consumption do not include the column headers. If you do not have column headers, you will have to add in column names later",
1 Reply
HI Anonymous
1. Could you please kindly share the guide you followed?
2. Is the column header available in the storage account in Azure?
From this article, "There are a couple of things to keep in mind when creating files for import. First, many files generated for big data consumption do not include the column headers. If you do not have column headers, you will have to add in column names later",