Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi alll,
In the Power Bi desktop i will from 'Sharepoint folder' the file`s there are like testing_28-02-2021.csv etc to
Combine & Transform Data
When i select the sample File i get this.
What do i wrong?
The files are .csv files and they are semicolon(;) separated .
Solved! Go to Solution.
Hi @Frixel
When you get to the screen asking you if you want to Comin, Load or Transform Data, click on Transform
In the Power Query editor you can now filter the files by Extension, to only show CSV files
From the resulting list of CSV only files click on the Combine icon in the Binary column to combine the files.
Regards
Phil
Proud to be a Super User!
Hi @Frixel
When you get to the screen asking you if you want to Comin, Load or Transform Data, click on Transform
In the Power Query editor you can now filter the files by Extension, to only show CSV files
From the resulting list of CSV only files click on the Combine icon in the Binary column to combine the files.
Regards
Phil
Proud to be a Super User!
Hi @Frixel
You can't combine CSV and XLS. PBI expects different data in each one. You'll need to import the CSV and Excel files separately.
regards
Phil
Proud to be a Super User!
How can i than select one folder PBI must look in?
The csv files are in a separate folder but PBI see also the oyher folders with the Exel files.
PBI do not exept if i select a specific folder like this:
https://mydomain-sharepoint.com/personal/mydomain-sharepoint.com/MainFolder/DataFolder/CSV_Folder/
Hi @Frixel
The sample file you have selected is an XLS file, not CSV. Are you trying to import/merge CSV or Excel files?
Sometimes the older XLS format generates funny errors. Can you try importing a single XLS file successfully?
regards
Phil
Proud to be a Super User!
Thanks for your quickly response.
The sample file is realy the semicolon(;) separated.csv file.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |