Forum Discussion
CSV file not uploading new rows automatically
Hello Mughees ,
When you say it is not uploading the enw rows what do you mean.
Also you have other transformations which may exclude specific rows. Have you checked that.
To make sure that all rows are loaded to PowerBI you should always check the first step in Power Query
I have a data set online that is updated and I download it in csv file format. So everyday, that file is updated and few new rows are added in it but number of columns remain the same. I just export that file in a specific folder and replace it with the old one. This file is linked to POWER BI. So if new rows are being added, they are not being loaded in POWER BI. I cannot figure out how can I check on power query this issue.
Looking at this reply I think I might know what's going around.
The Power BI works with data models, not the file itself, that way even if your file is online, in a onedrive or sharepoint folder, when you upload it again, the power BI datamodel keep the original data, from the file you used to create the dashboard, so, you have two options. Manually open the pbix file and click in "Refresh", or go to the workspace the file is publishd and set a routine for automatic refresh your data, this video might help you in that routine:
https://youtu.be/ClmZ-8p6x9g?t=281