🚀 Calling all data enthusiasts! 💼🌟 👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off! 🔗 Grab your discounted spot here: learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d 💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼 🔗 Explore the possibilities here: learn.pavanlalwani.com/courses/Power-BI-Dax-634fa813e4b0c08ed56c9919
Pavan, This was super helpful. I am appending raw csv files from a LinkedIn export. It is always in the same format, but it is not in tables. Do you have any advice about how I might append that data?
Hi Pavan, while appending multiple files of similar format when I added custom column in new column I got text as error. The file format is 1-16 rows is basic details of customer and from 17th row I have table format in all the files. What could have gone wrong. Thanks a lot for your excellent videos. Could you please let me know on this.
@PavanLalwani suppose we have multiple tables in particular first sheet of excel then is it possible to import each table from that single 1st sheet in powerbi
I have another query. Each excel file contains multiple sheets with different headers. (the contents are not in a table and I also don't want to convert it as table in excel). How can I set the first row as the header for each sheet while appending in Power Bi?
thanx sir ,,,, when you type excel. then automatically shows workbook option,,,,,, but in my case i have to type completely Excel.Workbook why ?? thanx
at 2:43 when you click on Binary at "content" column file size is displayed at bottom, when i try its directly navigating to that file /section. Do we need to change any setting for it?
🚀 Calling all data enthusiasts! 💼🌟
👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!
🔗 Grab your discounted spot here: learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d
💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼
🔗 Explore the possibilities here: learn.pavanlalwani.com/courses/Power-BI-Dax-634fa813e4b0c08ed56c9919
Thanks Pavan - you are brilliant and very explanatory👍👍👍
Sir.. Dil jeet liya.. what a explanation.. Thank you sir!
Thank you so much, Pavan!
I'm impressed with your video, crisp and clear, straight to the point. Truly amazing!!!
Thank you so much !!
Hii, this is very helpful you really save my day. thank youuu
Thanks Pavan! Everyone has a video on CVS but Excel is a little tricky
My pleasure
Explained in very simple way, great Pavan!!
Great @Pavan
Thank you so much. The video is so helpful and explained in such a nice and simple way. This will save me so much time.
You're very welcome!
Useful information
Pavan, This was super helpful. I am appending raw csv files from a LinkedIn export. It is always in the same format, but it is not in tables. Do you have any advice about how I might append that data?
Thank you😊😊😊😊😊😊😊😊
How to do the same from the sharepoint folder? Pls do a video
awesome clear and precise
is there any course on power bi including dax advance level
Very Nice Pavan. Appreciate
Thank you !!
Hi Sir - How to use this formula =IFERROR(IF(SEARCH("FCS",R2),"FCS") in power query
Can you show how to auto refresh on the Power Bi service online?
Hello Pavan, how could I refresh or load a chosen table? Because when I refresh or load the new data, it refreshes all the tables. Thank you!
Thank you.
When I do this..file append with heading.i ma appending Excel file...plz suggest
Hi Pavan, while appending multiple files of similar format when I added custom column in new column I got text as error. The file format is 1-16 rows is basic details of customer and from 17th row I have table format in all the files. What could have gone wrong. Thanks a lot for your excellent videos. Could you please let me know on this.
Hi Pavan
If i have to add columns in the table how do I get them in power BI after refresh of the data
Happy Birthday Sir..
Hi Pawan,
Clean names didn’t appear post selecting the data rather i had to promote headers which led to error. Please advise
Why didn't we click on Combine and Transform data as we did in the case of CSV files?
Yes same doubt I got
can we add excel sheet in power bi with calculation and formula?
Thankyou sir ..
@PavanLalwani suppose we have multiple tables in particular first sheet of excel then is it possible to import each table from that single 1st sheet in powerbi
Yes
Sir when appended the folder i am getting data source error how to rectify please help
Do you have any video that help me "count on of consecutive days and no of sequence" in power query. Thanks
Nice, Very good,
Hi. What if first I want to filter n group some data and want each file from folder to go through similar process before going into table?
What is purchase price of Power BI ???
Hi, can anyone tell, I have created custom column, but inside column, "error" is there not "Table".
Sir, @5:12 Custom.Name and Custom.Item are same (have the same name), what's the difference between them?
I have another query. Each excel file contains multiple sheets with different headers. (the contents are not in a table and I also don't want to convert it as table in excel).
How can I set the first row as the header for each sheet while appending in Power Bi?
thanx sir ,,,, when you type excel. then automatically shows workbook option,,,,,, but in my case i have to type completely Excel.Workbook why ?? thanx
When I click ok after clicking content in excel.workbook the custom column created is showing error.
same
Plz ..provided file which is u r explaining in video
Link in description
at 2:43 when you click on Binary at "content" column file size is displayed at bottom, when i try its directly navigating to that file /section. Do we need to change any setting for it?
With keyboard arrow key its working
Hi pavan sir can we have a session on power pivot options in power bi please
Sir, Can you upload Power Pivot videos
How this video differs from 14.1 ?
steps applied but when i am applying them to enter in power view its showing error
same here....getting error
put the ([content])
you did not share the file.. shared pbix
How to combine multiple excel file from multiple folders into power BI?
How to and where to purchase power BI
Please reply
How to purchase and where to purchase power BI
Sir this session I can't understand 😔