Edit Data in power bi manually || Power BI Merge Queries

Power BI video will teach you how to merge queries in power bi and how to manually edit your power bi data. you can learn lots of new power bi tricks and tips and use in your daily life.
one of the best tool in market which is free of cost #POWERBI
#MergeQueries
#MergeColumns
#PowerBidashboard
download link :- drive.google.com/file/d/1ZJxN...
****************************FOLLOW ON************************
Facebook :- / excelworldofknowledge
Twitter - / sohandey3
KZbin- / @gyanontube
Follow me on Instagram :- / gyan_on_tube
______________________
How to Use concatenate in excel || Replace vlookup and IndexMatch formula ⚡⚡ || Tutorial in hindi :- • How to Use concatenate...
New vlookup formula in excel || textjoin function in excel || index match function in excel :- • New vlookup formula in...
indexmatch excel || How to use index match formula from Basic to advance. :- • index match excel || H...
combination formula || How to make big formula in excel in hindi || combined variance formula :- • combination formula ||...
Xlookup for Free || New formulas for free || Xlookup and Filter formula in hindi :- • Xlookup for Free || Ne...
compress excel file || reduce excel file size || how to reduce excel file size in hindi :- • compress excel file ||...
How to use Xlookup in excel 😮 || xlookup formula in hindi 😮|| vlookup formula in excel :- • How to use Xlookup in ...
Array formula excel || array function in excel || Excel Vlookup ❌|| index Match Excel ❌ :- • Array formula excel ||...
xlookup in excel in hindi || Xlookup A to Z in details || New Xlookup with Search Mode :- • xlookup in excel in hi...
Xmatch formula in excel || Xmatch formula in excel in hindi || Xmatch with Index formula:- • Xmatch formula in exce...
filter formula in excel || how to use filter formula in excel in hindi 😮 filter formula in hindi :- • filter formula in exce...
Top 10 excel formulas 😮|| excel formulas and functions || excel functions and formulas :- • Top 10 excel formulas ...
How to use excel unique function || Excel unique formula in hindi || Remove duplicate values:- • How to use excel uniqu...
Drill Down in Pivot table excel || Classic Pivot table view in hindi :- • Drill Down in Pivot ta...
3D Pivot Graph in excel in hindi || Lean Pivot from beginner to advanced || lean pivot table:- • 3D Pivot Graph in exce...
excel slicer || how to use pivot table slicer || slicer in excel 2007 and above :- • excel slicer || how to...
advanced pivot tables || advanced pivot table excel || IF formula in Pivot :- • advanced pivot tables ...
Sort formula in excel || array formula in excel || how to use sort formula in excel :- • Sort formula in excel ...
interview questions and answers || interview questions || advanced Excel || Excel Interview 7 :- • interview questions an...
advanced excel :- Top 5 Advanced excel and word tips and tricks :- excel formulas in hindi :- • advanced excel :- Top ...
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 3 :- • Job Interview Question...
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 2 :- • Job Interviews questio...
Excel Interview Question 😮 MIS Interview Question in Excel in Hindi 😮 Excel Interview :- • Excel Interview Questi...
Interview question how to get first and last name in excel 😮 First and Last name in Excel in Hindi. :- • Interview question how...
Serial Number auto populate 😮सीरियल नंबर औटो पॉपुलटे कैसे करें 😮rows formula to populate serial no :- • Serial Number auto pop...
How to Change Excel background color In hindi ! office 2019 :- • How to Change Excel ba...
Advance Excel - Top 5 Excel Time Saving tricks 2018-2019 :- • Advance Excel - Top 5 ...
How to Separate all text available in a cell :- • How to Separate all te...
One Vlookup Multiple Worksheets :- • vlookup in excel !! बह...
*********(Gyan On Tube)***********

[@farazsiddiqui6334]

i am from nederland . belive me i been studies with Various Teacher all around world .but Gyan on Tube he really honest and sincered with his profession . kamal ki Teaching skill i must say Best Power bi Teacher on social media.

[@GyanOnTube]

Thank you so much for your valuable comment.. do not forget to share this video for better reach..

[@rishabhrishank4398]

I am enjoying your videos! Thanks for explaining everything in a very easier manner. Looking forward to learn more from you.

[@GyanOnTube]

Thank you so much for your valuable comment..do not forget to share this video

[@rajeshbansod5336]

It's really going easy to understand. When I started from other sources it seemed to be impossible but, you made it possible by doing it in a great & an easy way. Thank you so much for making a series on Power BI.❣😊

[@GyanOnTube]

Thank you so much 🙏

[@IrfanKhan-wv8rh]

Sir, your teaching method is all time wonderful.. Thanks sir

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@pawanmaske9236]

I am enjoying my study while watching your video sir it's very easy to undestand quickly.....you explained very well

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@binaykumar1616]

Very Good explanation. Your concept is very clear.........Thanks

[@GyanOnTube]

Thank you so much for your valuable comment ☺️

[@theabhishekshaww]

Thank you so much for sharing the information, this thing made an impression of mine in front of my Delivery manager. ❤

[@GyanOnTube]

Thats great.. amazing 👍

[@sadhanks1924]

seen many videos of powerbi and this is the best i have got

[@GyanOnTube]

Thank you so much 😊

[@raj87manish1]

Excellent series of videos

[@GyanOnTube]

Thank you so much for your valuable comment..keep sharing keep learning..

[@EasyExplain]

Great bhai. One of its kind.

[@GyanOnTube]

Thank you Akash all because of you..🙏

[@EasyExplain]

@@GyanOnTube why mentioning everytime? You are Doing great job. Keep rolling.

[@Peerwazifaofficial]

Salute you 💯👏 What a legend man of power BI you are hats of to you You really explain everything very very deeply that no one can explain like you I watched videos from many channels but I unsubscribed their channels cause they don't have skills like to you teach us Direct aapki baate sidhi samjh aati hai Great job But please do one favour I told you to please upload some videos on errors like in what condition to use Unpivot tablets, and many other that you replied on my comments please kindly take some time to upload that query videos Have a nice day

[@GyanOnTube]

Thank you Fahad Khan ji.. really appreciate your comments.. however as of now i font want to break the chain..for sure i will upload more videos as soon as i am done with my chain videos..i have noted your point..you dont worry you will get those video soon..

[@Peerwazifaofficial]

@@GyanOnTube thanks a lot But I have one problem this 2020 version is different from old version In that we can se icon Get data but here ?? Can you please let me know how can we get data And also what the difference between CSV and SQL Now a days company demand for SQL experts

[@GyanOnTube]

@@Peerwazifaofficial get data option is there in new one as well..which is called transform data under home tab...

[@Peerwazifaofficial]

@@GyanOnTube thanks a lot

[@nahidalam8847]

You're amazing bro!

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@rajputboy5296]

Thanks yaar

[@prachidixit460]

Bhut hi accha padhte hai itni vedio dekhi lekin aapki vedio h jisme samjh aya ❤

[@GyanOnTube]

Thank you so much 😊🙏

[@user-og1iz7uv5y]

Thanks sir bahut achhe se batta aapne

[@GyanOnTube]

Thank you so much

[@exclusiveglobaleducation2658]

really your explanation is very nice

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@saritas485]

Aap acha samjhatey ho sir

[@GyanOnTube]

Aapka Bahut bahut sukriya sarita ji..keep sharing keep learning

[@amanbhargava2702]

Thank you😊😊

[@GyanOnTube]

Thank you

[@abhishakya5263]

Sir...That sound "Tadan" was nice,☺️☺️😃

[@GyanOnTube]

😊😊

[@interestingfactsbysagartha6178]

Thanks❤ sir

[@GyanOnTube]

Thank you so much

[@pradeeppatwal6564]

Great learning vedio

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@technicalsyntax]

Best!

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@vishal-hf1fn]

❤️❤️

[@GyanOnTube]

Thank you so much

[@AjayT81]

Sir, I request you to make a video series of Power Query

[@GyanOnTube]

Point noted Ajay Kumar ji..but ei ek karke ji.. pehele aapni power bi khatam kar lu..fir power Query ki video banata hu..

[@pawanmaske9236]

Nice sir

[@GyanOnTube]

Thank you so much

[@swapnildas2212]

Hi Sir Beautiful way of teaching. I have a query When you populate country code in Reference data. Duplicate counrty name created. Can you explain on it. Time Elapse(8.06)

[@GyanOnTube]

Unable to understand.. please elaborate a bit

[@manishmanny2240]

Thank you so much, Sir, I smoothly learn Power BI. I have a query please let me know how to append the verticle sheet. now getting horizontal to data is not correct.

[@GyanOnTube]

Use transpose option

[@manishmanny2240]

@@GyanOnTube Sir, Thank you for your response... I will try the same..

[@GyanOnTube]

Thank you

[@jameerahmad9169]

Hi... I am unable to download that Excel file, there is required access from owner

[@GyanOnTube]

I have given the access to you please check now

[@vineetpurwar3197]

Lookup se v to kr skde ne Yeh cheej ? Ek column add krke

[@magalistudio7392]

Asslam o Alaikum bhai ap bht achhi tarah guide kartay hn ab aik problem he k 4 files ka ak visualization banay k doran files ko load krny k bad yh wala error a jata he Load was canceled by an error in loading previous table. Column 'Country' in Table. 'Refresh data' cotaine a duplicate value 'Algeria'and it is not allowed for on rhe one side of a many-to-one relationship or for columns that are used as the primary key of the table.

[@GyanOnTube]

Unable to understand your query

[@Akki-ri8nq]

Same mere m bhi yahi issue ho rha h solution pata laga.

[@akshaykulkarni4316]

Hello Sir, thank you for sharing wonderful knowledge with us. I would be so grateful if you could guide me on below issue..facing error after copying data from excel.. Facing error as "Expression:Error: The column "Column 1" of the table was not found

[@akshaykulkarni4316]

Could you please guide to solve this issue otherwise I can't proceed.Thank you in advance

[@GyanOnTube]

Change the column name as default..then it will work

[@akshaykulkarni4316]

@@GyanOnTube hi sir, please elaborate..when I can find this option? Sorry for trouble.

[@akshaykulkarni4316]

@@GyanOnTube problem solved...thanks a lot....appreciate your prompt response...

[@michellebangash3352]

@@GyanOnTube still same error

[@user-hx1hy4qh7s]

I create the region code column. Insert the data from excel. Data upload also. After some time it show as Expression Error. The table was not found.

[@GyanOnTube]

Have you deleted any column

[@user-hx1hy4qh7s]

@@GyanOnTube No, I didn't delete any columns. After paste the table icon on lift side change.

[@shaikhshabnam2946]

I am facing same issue

[@Troy_Health_Entertainment]

While merge file getting error Expression.Error: The column 'Column1' of the table wasn't found. Details: .. pleaese help to resolve this issue

[@GyanOnTube]

Have you changed name of the column

[@Troy_Health_Entertainment]

@@GyanOnTube No.. It is same as i download from you

[@Akki-ri8nq]

Sir I am trying to load the edit manually data but it is not downloaded. What can I do. Please tell me the reason. It is showing that we are unable to retrieve the contents of web page.

[@GyanOnTube]

Its called transform query

[@mohammedfaiz7308]

If i click source setting option it's showing file path and open file as. Which file need to be open?

[@GyanOnTube]

Sorry.. unable to understand your query

[@mohammedfaiz7308]

@@GyanOnTube I'm unable to edit the query manually, and I'm not getting the same option as you are showing in the Video

[@GyanOnTube]

Yes it got changed now...we called this power query now

[@aadvikdwivedilfisdelhi9966]

How to remove the duplicate entry of Country Name, i.e Albania country is showing 10 times.

[@GyanOnTube]

I have shown that as well try to follow the series..

[@mayankgupta4889]

Sir but its show limits of paste of data in "Enter data" of 3000 less

[@GyanOnTube]

Kya aap new file bana rahe hai power BI ke andar

[@parkhisinghal2270]

What's difference between merge and append query?

[@GyanOnTube]

For this i have already published one video

[@rajeshbansod5336]

Expression.Error: The column 'Column1' of the table wasn't found. Details: Column1 While making 'Merge Queries', Region Code ka sheet nahi dikh raha hai. please guide.

[@GyanOnTube]

Check the query editor column 1 is not available

[@sandhayatripathi8714]

Jb data paste kr rhe ho region main tb formula bar main jhna column likha h whna country kr do thik ho jayega main 2 din presaan rhi aaj ja k solution hua

[@sushanthande2607]

1. First Paste excel data as per video then got to reference data. 2. Come back again to Regional Code, now you can directly choose 1st row as header option to set column1 name to Country and Column 2 name - CODE, without any error. 3. Go to reference data > Merge Data > Select Country column from Reference data sheet > choose Region code data > Select Country column from Region CODE sheet > OK.

[@AshishGupta-kz1jh]

Sir, Excel में formula और function में क्या अंतर होता है ?

[@GyanOnTube]

Formula hai aapka jese 2+5 =7 and function is your =sum(a1,a2)

[@vasimuddinsheikh3766]

You cab debug formula but not function

[@GyanOnTube]

Who said we can not debug the function.. ofcourse we can..

[@vasimuddinsheikh3766]

@@GyanOnTube Dear Respected Sir I meant to say if we add the value by function =SUMIF(J17:J22,"A",I17:I22) & press Alt+T+U+F , It gives only result and does not show the step, but this is not the case with formula =SUM(IF(J17:J22="A",I17:I22)) if You debug this formula it gives you the step.... This is what I meant to say, May be I am wrong....

[@GyanOnTube]

Yes i think this make sense

[@garhwaligichhi534]

Hi sir, country code merge krne k baad code k column me table ara tha then i followed the same step as you but apka fir codes dikhne lge but mera null show hora hai sare codes.

[@GyanOnTube]

Kya aapne koi previous video skip kari hai

[@ajamalisaiyed1619]

I did the same but when I clicked on reference data and went back to the region code it showed me an error expression error: the column 'column1' of the table wasn't found

[@GyanOnTube]

Have you deleted any column

[@shyamchawda]

Save data after pasting data there

[@harun-or-roshid6287]

In this part I'm facing a problem :- I'm not getting Region Code on merge drop-down . Another problem ; when I'm going on Region Code then there is no table but show an error massage "Expression.Error: The column 'Column1' of the table wasn't found. Details: column1".

[@GyanOnTube]

Harun ji this is strange...try to watch complete video and do all the steps what we did..i am sure you might be missing some were..

[@harun-or-roshid6287]

@@GyanOnTube Thank you dada , it was not my mistake but solved

[@sheikhtauseefahmed1811]

@@harun-or-roshid6287 can u please tell me the solution i am having the same problem

[@GyanOnTube]

Great

[@sandhayatripathi8714]

​@@harun-or-roshid6287 i m also facing the same issue can u tell

[@himanshumalik1023]

hello sir, i love your teaching skills thanks for uploading this series but ek problem hai sir sab karne ke baad jab main close and aplly kar rha hu to ek error show kar rha hai which is " Reference Data Column 'Country' in Table 'Reference Data' contains a duplicate value 'Algeria' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. " ....please explain ki ye kyu dikha rha hai.

[@GyanOnTube]

To aap kya one to many ka relation de rahe hai..aap relationship ko change kar do many to many kar do

[@himanshumalik1023]

@@GyanOnTube sir is there any option to get a class from you .. please let me know if there is any possibility ..becouse I am stuck over here .

[@GyanOnTube]

Yes i am providing online classes for power BI..let me know if you wanna learn

[@himanshumalik1023]

@@GyanOnTube yes sir i am intrusting ....please let me know how can i get it .

[@himanshumalik1023]

@@GyanOnTube please reply how can I get online classes ?

[@misssoni377]

Yeah bhot mushkil se mere huwa...but properly clear nhi huwa..firse try karna hoga..data view me datas open nhi horrhe..something went wrong dialogue box baar baar arha hai..transform data me sara datas arhha but data view me we couldn't connect to your direct query data source aese dikha rha

[@GyanOnTube]

Kya aapne koi column name ko change kiya hai

[@misssoni377]

​​@@GyanOnTube Expression error coming on my screen ...The column Column1 of the table wasn't found....I didn't changed anything

[@GyanOnTube]

Need to check the model..post that only i can comment

[@farazsiddiqui6334]

Sir hum jub excel say data laikur araya thay tu hum nay country code kiun nahi selct kiya sirf sath mai country ko bhi laikur aye hain . in future agar hamaray refernce mai similar coulumn na ho to kia hum merge nahi kursaktay query . because agli video mai if condition wali mai aap nay excel say sirf age nikali dosra coulum copy nahi kiya . to hum nay is merge mai sirf country code ko akelay copy kiun nahi kiya?

[@GyanOnTube]

Aapka question thora sa confusing hai.. please explain again

[@kreenu5035]

Unable to download that excel....it seems ...requires access from owner

[@GyanOnTube]

Hi Reenu, Access provided

[@maneshkurkute8146]

Good Morning Sohan Sir ! Hope all is OK at your end ! Hope you and your family are safe and healthy ! Need your help please. I have followed all the steps but I get an error. In extreme left section where we can see all the Queries - the Region Code Query does not show Data symbol like all other sheets. Instead it shows a symbol - Yellow triangle with black exclamation inside it and on the main page the error message reads as: "Expression.Error: The column 'Column1' of the table wasn't found. Details: Column1" This error message is visible under 'Changed Type' under 'Applied Steps' on extreme right. Because of this error, when I try to use Merge Queries function, in the Merge box which opens up, in the drop down field where we need to select the sheet to be merged, this Region Code sheet does not show up. And I can't proceed further. Please can you help. Thanks in Advance !

[@GyanOnTube]

Yes please change the column name to the old one..once that is done the error will automatically remove

[@maneshkurkute8146]

@@GyanOnTube Great ! Sorted now ! I am able to proceed ahead with Merging function now. I was facing the same issue with Age Group in the next video. Tried your solution there also. Sorted and am able to proceed in the next video as well. You are Genius ! Thanks a lot ! Appreciate your quick reply. Love you !

[@GyanOnTube]

@@maneshkurkute8146 thank you so much for your valuable comment ❤️

[@raghavgaming9316]

Sir merge nhi ho pa rha hai??? Join kind - Leff Outer Then use fuzzy matching but ok ka option click nhi ho rha hai kya kru?

[@GyanOnTube]

Let me prepare one video on that topic

[@STATUSSHUBHAM]

Sir iska koi notes hota hai Ya Hindi me book hota hai agr hota hai to koun sa hai

[@GyanOnTube]

Bilkul hota hai..saare online mil jaaega aapko

[@elitebook9473]

hello sir jab apne merge kiya data region table ka uske baad column select kiya to country ke names double ho gaye unique ki jgha esa q hua.

[@GyanOnTube]

Usne dono column ko merge kiya hai...to dono column ki value populate karwai hai

[@uniqueasmrblissofficial]

Sir I am facing an issue ok button is not getting activated kindly help

[@GyanOnTube]

Please tel me

[@user-wd1lg3kp2v]

please tell me how can i upload excel file of country code?

[@GyanOnTube]

You need to download from description and then upload in pbi

[@snvlogs8558]

Sir , mera region code ka data merge queries main show nahi ho raha ha or bad main jab region code jo new querie create kara hu na usmain expression error show ho raha ha . Mujha samaj nahi aa raha kha par problem ho raha ha.

[@GyanOnTube]

Kya aapne saare same steps use kiya hai

[@snvlogs8558]

@@GyanOnTube yes sir main same step use kiya .

[@harishchoudhary8673]

Ukrine ka b code sir 110 hi h to ase dono ka code same ho gya h

[@renuyadav2652]

Have one query: While entering the data, region code we made but as we copy the data in it, expression error appears. How to resolve it

[@GyanOnTube]

What is the complete error

[@renuyadav2652]

@@GyanOnTube as i enter the data file will create but there were not sheet symbol on region code file. Expression error: the column of the table was not found, appears.

[@renuyadav2652]

@@GyanOnTube same symbol appears in ur video when you paste the data from Excel but that symbol transformed into the sheet symbol as you clicked on the reference data file, but when i did that expression error appears.

[@GyanOnTube]

Have you deleted any column

[@renuyadav2652]

@@GyanOnTube no i just paste the data from excel and as i move to the next file that error drop up

[@debabrataroy1777]

Sir, How can I add different suffix having same prefix in a column of power bi, like I have, col 1 col2 col3 Disha Eye Hospital Kolkata 135, Sreebhumi Disha Eye Hospital Kolkata 250, Kamarhati Disha Eye Hospital Kolkata 25, Tollygunge I wanna make col1 unique by adding like this, Col1 Disha Eye Hospital, Sreebhumi Disha Eye Hospital, Kamarhati Disha hospital, Tollygunge How can I do that in Power Query?

[@GyanOnTube]

Unable to understand your query

[@debabrataroy1777]

@@GyanOnTube Okay sir I'll try again

[@singhbains6903]

After adding Enter data and merged both files I have seen "null"in UNC code

[@GyanOnTube]

Is null is there then remove it

[@singhbains6903]

All null

[@GyanOnTube]

Not possible

[@rakeshdutta4777]

In Region code my showing is Expression error : The column 'column 1' of the table was't found.. Details: Column 1

[@GyanOnTube]

Have you changed name of your column..???

[@rakeshdutta4777]

@@GyanOnTube No sir

[@GyanOnTube]

Thos error only occurs if you change the name of a column

[@rukmanichablani349]

There is error is show when i save the following they say that dublicate data in column is not allowed

[@GyanOnTube]

Have you deleted any column

[@ankitdhupe9386]

Try removing duplicates

[@LalitGadhavi-rv8my]

4:59 sir region code wali querie me error aa rha hai Error: the column 'column 1' of the table wasn't found.

[@GyanOnTube]

Kaha par

[@LalitGadhavi-rv8my]

@@GyanOnTube sir vo applied steps me changed type cencel krne se ho gya

[@Pratikj457]

Or aap jo excel file o sab lete hai o file k link daal do please

[@GyanOnTube]

Wo already downloaded link mein hai

[@gitajalipatwa7139]

Bhaiya vs code bhi use krte hai power bi me

[@GyanOnTube]

Means

[@gitajalipatwa7139]

@@GyanOnTube hmane apka pura 37 video watch kiya , smj aya sare basic things , Maine Microsoft ka power bi ka document open Kiya to usme to vs code pr commond use Kiya hai jaise npm I pbiviz , npm i, pbiviz start pbiviz new ( filename)

[@gitajalipatwa7139]

Bhaiya Maine apko insta pr Microsoft ke document bheje hai , mujhe thoda confusion ho Raha hai desktop pr vs code ko lekr

[@GyanOnTube]

Ok let me check

[@priyankarauthan5697]

Not able to download that excel file, sir please accept the access request

[@GyanOnTube]

Hi Priyanka access provided

[@Pratikj457]

Sir mene kuch part practice krke save kiye but ab jab me usse access krta hu to o file open nahi hota

[@GyanOnTube]

Aap pbix file open kar rahe ho kya

[@Pratikj457]

@@GyanOnTube file me Jake o files open krta hu o open nhi hote

[@adityapandit2706]

Sir Request access for owner arha hai..

[@GyanOnTube]

Access provided

[@Enggabinashsahu]

Country code ka list mil sakta hai?

[@GyanOnTube]

Hanji bilkul..chek part 2, 3, 4

[@user-wd1lg3kp2v]

country code ki excel sheet kaha milegi koi bata skta hai?

[@GyanOnTube]

Description mein hi available hai

[@manishjonwal1144]

Power bi ke data ko Excel sheet mein kaise sev Karen

[@GyanOnTube]

Uske liye aapko copy and paste karna hota hai

[@itxsohail3989]

Reference data mai Algeria duplicate a raha ha... Data transform nahi ho raha

[@GyanOnTube]

Ab new option mein usko kehete hai transform query

[@suyogdesai_23]

Region code me error dikha raha he sir

[@ishtiaknizam3314]

You Posted this video 3 Times, if i am not wrong

[@GyanOnTube]

No this is only one video i posted..

[@paramjeet975singh3]

sir mege query aur appned query mai differnce samj ni aa raha hai ?? dono ka kam same hi hai ??

[@GyanOnTube]

Nhi merge and appned query dono alag alag hai..aap meri saare power BI ki video dekho aapko samaj aajega

[@paramjeet975singh3]

@@GyanOnTube apki sabi 17 videos dekh li hai.... Fir bhi confused hu sir.... Ho sake to ek bar reply karke bata diziye

[@GyanOnTube]

Aapko agar likh ksr bataunga to aur jyada confuse ho jaaoge..mein bahut jaldi aapke liye iske uper ek video bsna deta hu

[@paramjeet975singh3]

@@GyanOnTube ok sir thanx... Aur power pivot kaise karte hai power bi mai??

[@GyanOnTube]

@@paramjeet975singh3 question thora confusion hai aapka

[@raghuvendrakumar5605]

Sir error aa rha hai region code main

[@GyanOnTube]

Kya error hai

[@user-gl5mv9dj8x]

Country ki unique id kaha se laye Excel sheet me

[@GyanOnTube]

Uske liye aapko data ko remove duplicate karna hoga

[@ahmedshahnawaz5497]

Sir! Region code table mein excel file copy karne k baad, yellow color ka left side mein error symbol show ho rha hai jo ki khatam nahi ho rha, aur jab main reference data table se wapis Region code table mein arha hun to error show kar rha hai k coloum 1 not found.. Please help

[@GyanOnTube]

Merge mein esaa error to nhi hona chaiye.. please aapna data type change kar lena..

[@ahmedshahnawaz5497]

@@GyanOnTube sir merge mein error nahi arha, jab maine excel country code query mein copy kiya tha tab se left side mein error tab show kar rha tha, same was showing on your video also, but apka icon apne aap table icon mein change ho gya, mera change nahi hua error hi show kar rha hai

[@ahmedshahnawaz5497]

@@GyanOnTube due to this error file merge bhi nahi ho rahi, kyoun ki merges waley tab mein click karne k baad, second table select karne k liye drop down mein reigon code table show hi nahi kar rha

[@GyanOnTube]

Not sure esaa kiyo ho raha hai..bina data dekhe mein bata nhi sakta

[@ahmedshahnawaz5497]

@@GyanOnTube then sir! Please tell How to show you my data..

[@learnclub4168]

Sir 12 th lesson me country code kha se aya

[@GyanOnTube]

Meine prepare kiya hai..aap ne shayad pice wale videos skip kari hai..aap please wo check karo

[@mubashirnawaz1751]

Sir source m koii icon ni a ra

[@GyanOnTube]

Kya dikh raha hai aapko

[@Pratikj457]

Hume practice ke liye data nahi milta

[@GyanOnTube]

Niche description mein hai

[@ronitjaiswal5265]

Sir ye save nhi ho raha kyunki usme algeria two times repeat hua h

[@GyanOnTube]

Which one

[@ronitjaiswal5265]

@@GyanOnTube Sir dhyan se dekha m video m 8.11 algeria more than 1 time aaya h

[@GyanOnTube]

Ok

[@aniljangid1570]

Refrence code showing error

[@GyanOnTube]

One which one

[@learnclub4168]

Pure sata me to h hi nhi

[@GyanOnTube]

Means..??

[@learnclub4168]

Please reply

[@GyanOnTube]

Already replied

[@9860848074]

Thank you for Great Videos...

[@GyanOnTube]

Thank you so much

[@paramjeet975singh3]

not able to download file from descriptipn ??

[@GyanOnTube]

check now i have provided you the access