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.
HarishKM
Super User
Super Usermp390988 Hey,
kindly follow the below steps
I will suggest you to upload your csv file to sharepoint folder of your team common folder.
Then you can use sharepoint folder.
You have to remove x/r from your sharepoint url - https://yourcompanyname.sharepoint.com/yourfoldername/
then you can select or filter down your csv file then you are all set here.
Did I answer your question? Mark my post as a solution! and Give Kudos as well
Thanks
Harish M