Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm working on building a dashboard for a client, and I could use some advice as to the best way to input their data. They will be sending us both CSV and TXT files that are updated monthly, and they all need to be appended into a single table. What would be the best way for me to ensure that all of the new data files are successfully and efficiently added to the "master" append table? I will have quite a few calculations running off of this table as well.
Thanks in advance!
Solved! Go to Solution.
@Anonymous , You can use any of the formats. If there is column where you expect "," to part of the value use tab-delimited \t file or some other delimiter. CSV is a standard format. If the text is enclosed in double-quotes you can have a comma in text. The number should be formatted.
Refer these too
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
@Anonymous , Try if these can help
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
@amitchandak Thank you! Do you have any thoughts on how best to upload the data? We recieve CSV and TXT files monthly, so my thought was to add them all to a folder, and use Get Data > Folder to import.
@Anonymous , You can use any of the formats. If there is column where you expect "," to part of the value use tab-delimited \t file or some other delimiter. CSV is a standard format. If the text is enclosed in double-quotes you can have a comma in text. The number should be formatted.
Refer these too
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |