@CorneLaros
@Goodly At around 56:20 - 56:30 you say that a user would have to go into Power Query Editor to change the parameter. In Power BI you actually don't have to. You could go to the 'Transform Data' button, click on the arrow, rather than the button, and edit the parameter in report view. This is easier and faster than loading Power Query. Anyway, thanks for the webinar, I learned a lot!
@rajavintemakhan
Thank you for your support 🙏 and you have a good communication skills as well..
@ginesc
Long trick number one !!! indeed,,,, hahahha and incredibly goooooooood :-)
@jamescullis
awesome video thank you. another snippet when promoting headers is to ignore the first x rows. In my example I'm removing the first 10 rows --- Table.PromoteHeaders(Table.Skip([Data],10) --- hope that helps someone
@ratneshbansal5139
@chandeep: The automation we do for different columns or sheets in the video doesn’t work if the data type is different in one of the files. I tried using this technique with date conversions (let…in) from your other video and it didn’t work because one of my files had source as text and other had source as numbers!
@eslamfahmy87
Good tutorial as usual, but if I have inconsistent null numbers, sometimes 4 and sometimes 5 or more how we can deal with that
@chahineatallah2636
hi Chandeep, as usual great tips, why for dynamic path am getting some formula firewall error ? what i was doing is that i created a new sheet and in the sheet i created path header and then cell with the address by using cell function & transformed it into a query , but when am using it its giving some formula.firewall error, any video on this error? :)
@akanshmittal3189
Is it that Excel.Workbook function doesn't work on .XLS file? I tried in my m/c (excel2016) but wasn't able to. Was working fine when I converted XLS files to xlsx. Pls let me know any trick to cut short the time spent in converting XLS to xlsx
@nikahafiz1
hi chandeep, i'm developing a power bi dashboard app for a shared services co that has about 50+ organizations. the app gets ms excel files that are generated by an accounting cloud app every month. i use power bi's power query tool to clean up each individual organizations (so, i do it repeatedly 50+ times every month) as i need to also add an organization identifier (org_id) for each of the organizations. subsequenly, they are merged also through power bi's power query tool to create a dataset for subsequent reports/dashboard to use. the org_id will be used for filter purposes later. is there a way to avoid the repetitive routine?
@raulparra60
Desde Bogota-Colombia Gracias muy interesante
@KawanExcel
Thank you so much for the enlighten , Sir :)
@venkatareddykummitha5863
is it same for power bi
@thebhaskarjoshi
awesome video
@Osmanfayyaz
very Good session
@shivbansal453
WHEN I AM TRYING TO PULL ALL EXCEL IN ONE I GET ""External table is not in the expected format." My source excel file is .xls in which i need to accept the trust dialog box and then enable editing... how can i bypass this error? Kind if you can help
@mostafaabdalla9636
Thank you so much. Brillient
@romeop2345
Hey mate, I am new to power query here, when categorising bank statements in power query, do you have any ideas how to sort out columns which would have multiple if statement criteria, (If text is contained in the bank statement - if and, if not to be in this category , else, this category etc).. when there are like 50 categories.. any code you know which has a quick way of doing this? Your orecii videos have been very helpful so far so many thanks.
@stephenmuigai5868
Very helpful indeed. I have sheets where the column headers are in different rows in each sheet. How can i align them?
@kebincui
Thanks Goodly :)
@shoaibrehman9988