Power Query :Getting Data from Current Workbook Table/Range to Power Query

Поділитися
Вставка
  • Опубліковано 6 січ 2025

КОМЕНТАРІ •

  • @Faruksiyar6932
    @Faruksiyar6932 4 дні тому

    Your teaching style Excellent 👌

  • @RakeshSingh-yd7xo
    @RakeshSingh-yd7xo 3 роки тому +2

    After taking a new job, I became a bit lazy, but I know continuous learning is very important to grow further in life. So I decided to start learning new things that's why I rejoined your channel again because there is no better learning platform than your channel. I am starting playlist-by-playlist from where I left the videos. Thank you So Much Sir for the new playlists.

    • @Innozant
      @Innozant  3 роки тому +2

      Wow Great Rakesh Ji..This is what i expect from You.. Happy Learning ahead ❤️🙏

  • @TheSuvankarKundu
    @TheSuvankarKundu 3 роки тому +1

    The best part of your channel is.. You r teaching every one without charging a penny.. God bless you sir....🙏🙏🙏

    • @Innozant
      @Innozant  3 роки тому

      Thanks Suvankar..Mera maqsad youtube platform par aane ka pura hota najar aane laga hai..m really happy ki aplogon ke life me value add kar pa rha hu

    • @TheSuvankarKundu
      @TheSuvankarKundu 3 роки тому

      @@Innozant i don't know abt others sir.. Aapse sikhne k baad , i gave some improvement ideas in my company nd got GB certification.. Thanks a lot sir..

    • @Innozant
      @Innozant  3 роки тому

      Wow...Love You Suvankar ...Proud of you...Thanks 😊

    • @TheSuvankarKundu
      @TheSuvankarKundu 3 роки тому

      @@Innozant Thnx to you sir.. It became possible only bcz of u nd ur vds..

  • @essamuhammad6393
    @essamuhammad6393 2 роки тому

    great teacher's brilliant teaching

  • @pramodbhavsar4488
    @pramodbhavsar4488 3 роки тому

    Very Frist tutorial of power bi is good explained with simple method and information about database very nicely thank you sir for starting power query editor

    • @Innozant
      @Innozant  3 роки тому

      Thanks Pramod Ji..Happy Learning Power Query series

  • @pramodmishra2680
    @pramodmishra2680 Рік тому

    This is very good channel for learn excel on proper functioning and easy way

  • @shivaaryaprakash
    @shivaaryaprakash Рік тому

    explained in a very good way and cover each point. Thank you

  • @ArmaanKing17
    @ArmaanKing17 9 місяців тому

    Awesome teaching method! Lots of respect from Pakistan

    • @Innozant
      @Innozant  9 місяців тому

      Thanks.keep Learning

  • @iamsainipawan
    @iamsainipawan 3 роки тому

    How simplicity you understand the concept of power query is unbelievable good teaching skills hope you understand the concept as well as power bi👍👍👍🙏🙏🙏🙏

    • @Innozant
      @Innozant  3 роки тому

      Thanks Pawan for your valuable appreciation..Gid bless you dear❤️

  • @jksunique2463
    @jksunique2463 3 роки тому

    Sure 100% samajh me aayega..
    Awesome Sir.. waiting interesting further power query tutorial videos..

    • @Innozant
      @Innozant  3 роки тому

      Thanks Jitnedra Ji..for showing your trust and love

  • @jayantabhattacharyya628
    @jayantabhattacharyya628 3 роки тому

    Dear Sir
    Excellent teaching technique. This is the reason I like your tutorial very much. I hope I will learn power query properly under your guidance.
    Thanks & Regards
    Jayanta Bhattacharyya

    • @Innozant
      @Innozant  3 роки тому

      Tha Jayanta for showing your trust and love dear..happy learning

  • @kishupatel2839
    @kishupatel2839 2 роки тому

    👍👍 Excellent Studying Platform 👍👍

    • @Innozant
      @Innozant  2 роки тому

      Thanks Kishu Patel ji.happy learning ❤️

  • @Shubham-xy6xh
    @Shubham-xy6xh Рік тому

    To good content you provide us love you sir 😅

  • @shrikantbadge3978
    @shrikantbadge3978 3 роки тому

    Amazing amazing amazing knowledge. M waiting for march ending to revise everything. Bahut धन्यवाद दीपक sir.

    • @Innozant
      @Innozant  3 роки тому

      Thanks Shrikant ji..Happy learning dear

  • @satishojha6240
    @satishojha6240 3 роки тому

    Awesome sir very informative video next video waiting thanku sir good morning have a great day. 🙏🙏🙏

    • @Innozant
      @Innozant  3 роки тому

      Thanks Satish ji..Good Evening

  • @ikshitsharma7074
    @ikshitsharma7074 Рік тому

    Thanks sir for sharing. It's really helpful

  • @farrukhshahzad3744
    @farrukhshahzad3744 2 роки тому

    very comprehensive !! Bravo👍

  • @tejpalsain1507
    @tejpalsain1507 3 роки тому

    Very useful and important for us.
    Thanks.

  • @pawankumar-ld6jq
    @pawankumar-ld6jq 3 роки тому

    Really, "useful video"
    Sir 🙏🙏🙏🙏

  • @Md.Ismail-v1e
    @Md.Ismail-v1e 10 місяців тому

    Good morning Sir,
    Very Very Excellent
    Thank you Sir,

  • @asifkhurshid9208
    @asifkhurshid9208 2 роки тому

    Excellent explained. Thanks and regard.

  • @aqeelahmadengr3
    @aqeelahmadengr3 3 роки тому

    Good videos for improving Excel

    • @Innozant
      @Innozant  3 роки тому

      Thanks Aqeel Sahab.

  • @hemantsharma4896
    @hemantsharma4896 2 роки тому

    Amazing videos sir🙏🙏🙏

    • @Innozant
      @Innozant  2 роки тому

      Thanks Hemant Ji❤️👍

  • @IAM___SAM
    @IAM___SAM 3 роки тому

    Appreciate your effort 👍👍👍👍

    • @Innozant
      @Innozant  3 роки тому

      Thanks Shuja...Happy Learning

  • @shrikantbadge3978
    @shrikantbadge3978 Рік тому

    just revising and realized that Dilip sir perfectly catches students perspective who is learning P.Q. first time. Just speechless.

  • @mjaved701
    @mjaved701 3 роки тому

    Great sir. I am anxiously waiting for next vedio of power query

  • @nazarkamal8831
    @nazarkamal8831 Рік тому

    Thanks bhaiya ❤❤❤

  • @RahulChauhan-ll9pu
    @RahulChauhan-ll9pu 3 роки тому

    Zebredast guru ji 👍🙏

    • @Innozant
      @Innozant  3 роки тому

      Thanks Chauhan sahab.

  • @awaiskhan8135
    @awaiskhan8135 2 роки тому

    Well explain.easy to urderstand.

  • @nayankumar7342
    @nayankumar7342 Рік тому

    You are great sir

  • @surendrarajput731
    @surendrarajput731 Рік тому

    Sir Really Great

  • @hsgusain2054
    @hsgusain2054 3 роки тому

    Thanks a lot 🙏🙏🙏

  • @kushwahachpyare2588
    @kushwahachpyare2588 3 роки тому

    superb sir g 👌👌👌👌👌

  • @kashifqasim8069
    @kashifqasim8069 Рік тому

    Real A great teacher

  • @brijeshmishraallahabad465
    @brijeshmishraallahabad465 Рік тому

    Sir, when use power query editor to merge two tables it shows data initialisation error.
    How to overcome over this type of error.

  • @muhammadyounis2686
    @muhammadyounis2686 2 роки тому

    nice info sir
    love from Karachi 🇵🇰

    • @Innozant
      @Innozant  2 роки тому

      Thanks dear .keep learning ❤️

  • @chayanbhattacharya1736
    @chayanbhattacharya1736 Рік тому

    Wonderful video

  • @sanjeebsen8827
    @sanjeebsen8827 3 роки тому

    Sir very very impressive how you make understand.... Request you to make a series of Power BI too...

    • @Innozant
      @Innozant  3 роки тому

      Thanks dear...Power BI series starts soon

  • @onlyexcel493
    @onlyexcel493 3 роки тому

    Superrr duperr sir... You explain very well sir

    • @Innozant
      @Innozant  3 роки тому +1

      Thanks Nileshgiri Sahab.

    • @onlyexcel493
      @onlyexcel493 3 роки тому

      @@Innozant w.c my dearest sir

  • @prajwalshetty2047
    @prajwalshetty2047 3 роки тому

    Nice Video 👍

  • @rohanparakhe4976
    @rohanparakhe4976 3 роки тому

    Great video sir

  • @AdityaSingh-xj2hy
    @AdityaSingh-xj2hy 3 роки тому

    Thank you sir 🙏

  • @deepakchauhan4974
    @deepakchauhan4974 3 роки тому

    Nice video jha ji

  • @abdulwaki8590
    @abdulwaki8590 2 роки тому

    Love you sir regarding

  • @RA-rh5lb
    @RA-rh5lb Рік тому

    thank you sir ji..

  • @santoshkumar-ud7jb
    @santoshkumar-ud7jb 2 місяці тому

    Very nice

  • @ajaysaroha2539
    @ajaysaroha2539 3 роки тому

    Superb...

  • @manik8164
    @manik8164 Рік тому

    When I Salect tab (Close and Load) excel popup- Initialization of the data source failed

  • @sudhasomasundaram1509
    @sudhasomasundaram1509 Рік тому

    Is there a place where I can see the videos sequentially. I know you mention previous video and next video but would like to have a list I can follow so I dont miss any topics. Thank you!

    • @Innozant
      @Innozant  Рік тому

      Kindly watch video in sequence playlist wise .All videos categorised under respective Play list.

    • @vipinandel6290
      @vipinandel6290 Рік тому

      in youtube search for innozant power query playlist or just search innozant power query and the on the top left corner you will find filter option from where you should select playlist as option and this will lead you to playlist of the required series

  • @Mahadev_ki_krupa-k1p
    @Mahadev_ki_krupa-k1p Рік тому

    Sir mere system me Excel 19 me load and closed krne ke bad sheet pr table nahi aaraha hai

  • @RinkuDevi-uq7yq
    @RinkuDevi-uq7yq 2 роки тому

    Maza aa gya guru ji

    • @Innozant
      @Innozant  2 роки тому

      Thanks Rinku..Happy Learning

  • @rakeshmlearningentertainme6099
    @rakeshmlearningentertainme6099 2 роки тому

    nice video

  • @dsinharay
    @dsinharay 3 роки тому +1

    Thanks a lot, sir please introduce M language with power query tutorial .

    • @Innozant
      @Innozant  3 роки тому +1

      Soon.
      Alreadt started Power query series a
      ,after some time you may able to see each and every content of power series

  • @sonukumarskp6933
    @sonukumarskp6933 3 роки тому

    Sir Aapke paid course ke baare me complete video banaye ..hame ek auchhe level ke MIS executive banna hai

  • @animals-video261
    @animals-video261 3 роки тому

    Good one..sir plz make a video on my provided query

  • @avinayakchoudhary4172
    @avinayakchoudhary4172 3 роки тому

    Thanks sir

  • @AshishKumar-hc3km
    @AshishKumar-hc3km 3 роки тому

    Nice sir
    Kya ye mujhe Mis report banane me help karega .

    • @Innozant
      @Innozant  3 роки тому +1

      offcourse..data cleaning bht aasan hoga isse

  • @RAKESHKUMAR-qw9cn
    @RAKESHKUMAR-qw9cn 3 роки тому

    Sir isame coding ka bhi part hai hai ye power BI ka topic hai.

    • @Innozant
      @Innozant  3 роки тому

      Yes based on M language .

  • @sawaimalhi8439
    @sawaimalhi8439 2 роки тому

    namaste sir ji jab main power query editor open krta hoon tu peche aaap ki trah excel file show nhe hote hai wo kise hoga? ek sath please batye

  • @RajendraKumar-ds6qs
    @RajendraKumar-ds6qs 3 роки тому

    Sir,MS Access ke baare mein bataye plz

  • @abhinavjaiswal3105
    @abhinavjaiswal3105 3 роки тому

    Sir please make video for MS Access also

    • @Innozant
      @Innozant  3 роки тому +1

      Noted ..bnayenge dear

  • @thegreaticons5071
    @thegreaticons5071 11 місяців тому

    Sir mere microsoft 2007 ne table range ka option nhi aa rha

  • @umaghosh1282
    @umaghosh1282 2 місяці тому

    Sir, what to do if files are password protected,

  • @SheetalBhagwat17
    @SheetalBhagwat17 Рік тому

    But mera toh queries nd connection ka option hi nhi aa rha..sirf workbook queries aisa option h

  • @kumkumchakraborty2892
    @kumkumchakraborty2892 Місяць тому

    sir, please SQL tutorial

  • @suhagmiah3559
    @suhagmiah3559 2 роки тому

    PRACISE FILE IS NOT AVAILABLE.

    • @Innozant
      @Innozant  2 роки тому

      It is there .. please find in video description direct link

  • @ramanmangat3320
    @ramanmangat3320 3 роки тому

    Nyc sirr

  • @meriawaazhindi5217
    @meriawaazhindi5217 Рік тому

    ❤️❤️❤️❤️❤️

  • @delhibala9294
    @delhibala9294 3 роки тому

    Hlo sir aapne sir vacancy ka btaya nhi sir bta dete?

  • @dmeyufta3415
    @dmeyufta3415 3 роки тому

    greeeeeeattttt

  • @ronakdave5692
    @ronakdave5692 3 роки тому

    Sir I have some questions
    I m working As a Mis executive
    and me jo kam karta hu office me wo data row 300k hota hai ab usme formulas and pivot and all lagaya he per Jab b kuch karta hu update to 30 min pakka hai mera Kya aap bata sakte hai ke power query me blank Column add kese kare ? formulas kese lagaye pivot kese kare sir yah 3 question hai pls rply me and help me

    • @Innozant
      @Innozant  3 роки тому +1

      Offcourse bht aasani se lar sakte hain..power query series me bht jald seekhne ko milega aapko

    • @ronakdave5692
      @ronakdave5692 3 роки тому

      @@Innozant thank you sir

  • @devbhumi7072
    @devbhumi7072 2 роки тому

    guruji load worksheet failed aa rha h

    • @Innozant
      @Innozant  2 роки тому

      ??

    • @devbhumi7072
      @devbhumi7072 2 роки тому

      Sir power query me load data pe click kr rha hu to lod worksheet failed aa rha h

  • @deepakKumar-zl1jl
    @deepakKumar-zl1jl 2 роки тому +1

    Table range ka toh option hi nahi aa raha hai

  • @trueadvisers
    @trueadvisers 3 роки тому

    Your voice is like shahrukh khan 😂

    • @Innozant
      @Innozant  3 роки тому +1

      Thanks for your appreciation 🙂❤️❤️🙏🙏