Forum Discussion

cdok1091's avatar
cdok1091
Advocate II
9 years ago

dynamically import files from a folder WITHOUT combining them

Hi all, I'm looking to upload multiple files of the same type from a single folder into Power BI Desktop.  However, in this case, I don't want to combine them into a single query.  How can I dynamic...
Need Help
ajuanto's avatar
ajuanto
Frequent Visitor
8 years ago

Hi ImkeF,

 

Thank you for the support so far. I came across an issue, could zou have a look?

 

 

I had a trouble visualizing my output in Power BI. I have imported more than 1500 CSV files but every time I visualize it, it only shows 10 CSV files that are randomly selected among the 1500 CSV files.

enter image description here

enter image description here

enter image description here

enter image description here

  1. How can I see all 1500 CSV visualization at once rather than just 10 CSSV?

  2. If it's not possible then I wanted to know how is 10 CSV files selected out of 1500 CSV files? Is there any calculation involved or is it just a random selection that Power BI dose on its own?

  3. In image4 I would like to know how the calculation is di=one for Average, Sum, Medium, and Maximum.

I have attached screenshots for reference. I tried using various filters but none has given me the desired output. In Image4 you can see that I can select the Sum Average Minimum Maximum and other filters....but neither worked.

ImkeF's avatar
ImkeF
Community Champion
8 years ago

I havent used visuals with that many series so far and cannot tell the limitations unfortunately.

I recommend to search specifically in this forum or create a new thread.

cheers, Imke