Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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/
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
66 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |