Excel and SQL server

%3CLINGO-SUB%20id%3D%22lingo-sub-2348112%22%20slang%3D%22en-US%22%3EExcel%20and%20SQL%20server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348112%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Community%20!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20pulled%20data%20from%20the%20sql%20server%20in%20excel%20and%20I%20have%20used%26nbsp%3B%20the%20excel%20file%20in%20Power%20bi%2C%20Now%20i%20would%20like%20to%20change%26nbsp%3B%20one%20of%20the%20column%20but%20the%20would%20excel%20file%20should%20be%20connected%20to%20power%20bi%20!!!!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx%2C%20i%20have%20deliverydate%20column%20in%20excel%2C%20which%20I%26nbsp%3B%20got%26nbsp%3B%20sql%20server%20%2C%2C%26nbsp%3B%20now%20i%20want%20to%20change%20the%20deliverydate%20column%20to%20invoiced%20column%2C%2C%2C%20which%20is%20again%20in%20sql%20server%2C%2C%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2348112%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2350022%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20and%20SQL%20server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350022%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F996191%22%20target%3D%22_blank%22%3E%40UserExcel%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20So%20you%20pulled%20data%20from%20sql%20into%20excel%3C%2FP%3E%3CP%3E2.%20Then%20you%20used%20the%20excel%20to%20Power%20Bi%3C%2FP%3E%3CP%3E3%20Then%20you%20pull%20data%20from%20sql%20into%20excel%20save%20it%20as%20the%20file%20name%20you%20used%20in%20excel%20with%20a%201%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%3A%3C%2FP%3E%3CP%3EFileName.xls%3C%2FP%3E%3CP%3EFileName1.xls%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20you%20point%20your%20Power%20Bi%20to%20look%20at%20FileName1.xls%20instead%20of%20FileName.xls%3C%2FP%3E%3CP%3ESo%20what's%20the%20problem%3F%20Your%20only%20possible%20problem%20is%20what%20did%20you%20do%20in%20Power%20Bi%20that%20will%20affect%20the%20results%20in%20Power%20Bi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello Community !!

 

I have pulled data from the sql server in excel and I have used  the excel file in Power bi, Now i would like to change  one of the column but the would excel file should be connected to power bi !!!! 

 

Ex, i have deliverydate column in excel, which I  got  sql server ,,  now i want to change the deliverydate column to invoiced column,,, which is again in sql server,,, 

1 Reply

Hi @UserExcel ,

 

1. So you pulled data from sql into excel

2. Then you used the excel to Power Bi

3 Then you pull data from sql into excel save it as the file name you used in excel with a 1 

example:

FileName.xls

FileName1.xls

 

Then you point your Power Bi to look at FileName1.xls instead of FileName.xls

So what's the problem? Your only possible problem is what did you do in Power Bi that will affect the results in Power Bi.

 

Cheers