🚀 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
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?
@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
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?
I have 4 files and in all files asset id is common for all but asset status is different and due to this duplicate assets are showing but when trying to remove duplicate only one file having completed data and other date data showing less number of asset id, pls help on this
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.
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
🚀 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👍👍👍
Thank you so much, Pavan!
I'm impressed with your video, crisp and clear, straight to the point. Truly amazing!!!
Thank you so much !!
Sir.. Dil jeet liya.. what a explanation.. Thank you sir!
Explained in very simple way, great Pavan!!
Hii, this is very helpful you really save my day. thank youuu
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!
Thanks Pavan! Everyone has a video on CVS but Excel is a little tricky
My pleasure
Useful information
Thank you😊😊😊😊😊😊😊😊
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
Very Nice Pavan. Appreciate
Thank you !!
Sir, @5:12 Custom.Name and Custom.Item are same (have the same name), what's the difference between them?
awesome clear and precise
is there any course on power bi including dax advance level
@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
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?
How to do the same from the sharepoint folder? Pls do a video
Why didn't we click on Combine and Transform data as we did in the case of CSV files?
Yes same doubt I got
When I do this..file append with heading.i ma appending Excel file...plz suggest
Can you show how to auto refresh on the Power Bi service online?
Hi Sir - How to use this formula =IFERROR(IF(SEARCH("FCS",R2),"FCS") in power query
I have 4 files and in all files asset id is common for all but asset status is different and due to this duplicate assets are showing but when trying to remove duplicate only one file having completed data and other date data showing less number of asset id, pls help on this
Do you have any video that help me "count on of consecutive days and no of sequence" in power query. Thanks
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..
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!
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?
Hi Pawan,
Clean names didn’t appear post selecting the data rather i had to promote headers which led to error. Please advise
Nice, Very good,
Sir when appended the folder i am getting data source error how to rectify please help
Thank you.
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.
When I click ok after clicking content in excel.workbook the custom column created is showing error.
same
can we add excel sheet in power bi with calculation and formula?
Plz ..provided file which is u r explaining in video
Link in description
Hi, can anyone tell, I have created custom column, but inside column, "error" is there not "Table".
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
Thankyou sir ..
steps applied but when i am applying them to enter in power view its showing error
same here....getting error
put the ([content])
Hi pavan sir can we have a session on power pivot options in power bi please
What is purchase price of Power BI ???
Sir, Can you upload Power Pivot videos
How to combine multiple excel file from multiple folders into power BI?
How this video differs from 14.1 ?
you did not share the file.. shared pbix
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 😔