Forum Discussion
Prefer CSV or JSON for my dataflows
Hi, I am new to PowerBI and will appreciate any help with my question. I have created multiple dataflows which extracts data from folder locations in my file system with the help of an on-pr...
I can't find it at the moment but I did see a blog comparing load times and think csv came out top. Under the hood when you run a data flow it stores the data as csv in azure data lake storage so it's very optimised for that sort of thing.
My hunch would be that you're unlikely to notice a huge difference. (Worth testing!)
Hi bcdobbs ,
Do you mean to say that, according to that blog, csv seemed to be taking the least time? It would be great if you could direct me to that blog or any other source discussing this issue.
Also, yes I have made separate dataflows to perform the extraction and transformation operations on. This actually does help a lot.
Best Regards,
Diptanshu Lal