Forum Discussion
I really need help building this report.
It really depends on the data. Power Query will not show you how many rows there are unless you go to the Transform tab and click on the Row Count button, but that will process everything to do it.
3 folders of various CSV files doesn't tell me much. If those CSVs are 10-15GB each, then yeah, that will take a while. It also depends on the transformations. The total dataset could be 50K records (small) but if you are doing something like a table scan in Power Query (using Table.SelectRows inside a custom column for example) then that won't load. Power Query is horrible at that kind of thing.
So to help, we need a lot more information.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Community ChampionIt really depends on the data. Power Query will not show you how many rows there are unless you go to the Transform tab and click on the Row Count button, but that will process everything to do it.
3 folders of various CSV files doesn't tell me much. If those CSVs are 10-15GB each, then yeah, that will take a while. It also depends on the transformations. The total dataset could be 50K records (small) but if you are doing something like a table scan in Power Query (using Table.SelectRows inside a custom column for example) then that won't load. Power Query is horrible at that kind of thing.
So to help, we need a lot more information.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.