May 12 2021 03:33 AM
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,,,
May 12 2021 06:05 PM
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