Forum Discussion
mp390988
Post Partisan
Post PartisanDealing with a huge csv file
I recently saw a post that one person claimed they had difficulties in loading a 12MB csv file into power bi desktop. Their solution was to use dataflows - which I don't understand. I don't...
I heard Dataflows is good for situations where one does not have permissions to access the database but another user doesalso called "breaking the security chain of custody" - I can not endorse that.
dataflow can be used as tool to reduce the semantic model size by trying to push much of the transformations away from the semantic model into the dataflowDataflows are glorified CSV files. Do these transforms at your own risk.
can a dataflow be used by a report in a different workspace?yes. Reusability is one of the positive features of dataflows. You will still need to have access to that "other" workspace.
mp390988Post Partisan
Post PartisanWhen you append additonal CSV files to the semantic model as you have mentioned, how does it know which CSV files are the new ones to append? Otherwise it will append the ones that have already been appended in the last refresh? Basically, how does Power BI identify the new CSV files?
lbendlin
Super User
Super UserPower BI has no memory. You need to do that partition management yourself.