Forum Discussion

HadasSpier's avatar
HadasSpier
Icon for Helper I rankHelper I
5 years ago
Solved

Get data- Folder contains CSV files

Hi everyone,   The folder contains CSV files with more or less similar columns but in a different order. For example: CSV1 contains columns: A, B, C, D CSV2 contains columns: A, D, C, B CSV3 co...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, HadasSpier 

    There is no restriction on how large a pbix file can be locally. However, when you publish a pbix file over 1GB to Power BI Service, you will get a file size limit message. 

     

    I cannot reproduce the problem you encountered. Everything is working well on my side, and there will be no case of putting column A into column B. It is recommended to recheck the column names of your related tables.

    If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

     

    Best Regards,
    Community Support Team _ Eason

HadasSpier's avatar
HadasSpier
Icon for Helper I rankHelper I
5 years ago

Hi!

If the header name is the same and the data type is the same, but when I use Folder and "Combine and Transform Data" I have errors and it didn't put them together (for some of the CSVs)
I think maybe it is not working because my data is too heavy?

 

Thank you!!

StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
5 years ago

you should post the error over here with image for better asistence, this way we can look over the error. in the best cast scenario post a dummy data pbi with the error and dummy data files. 

  • HadasSpier's avatar
    HadasSpier
    Icon for Helper I rankHelper I
    5 years ago

    Hi,

    The error is due to the fact that it switched between the fields.
    I.e. put column A in B and so on. I'm wondering if this is because I have a lot of CSV files in the folder I loaded (83) each of them is 150,000KB.

    Thank you!