Forum Discussion

venug20's avatar
venug20
Resolver I
8 years ago

Sale & Marketing Data Source Connect to SQL Server Error

Hi experts, I am trying to connect data source “SQL Server” from advanced editor, which I was download from Microsoft “Sales & Marketing Sample.PBIX” file. My Server name is : DESKTOP-F125T7K And ...
Need Help
venug20's avatar
venug20
Resolver I
8 years ago

Thanks for reply Seward,

 

I am very new to Power BI....

 

i want to do practice with "Sales & Marketing sample.PBIX", can get from microsoft sample provided.

 

I am trying to edit with power query, in this situation it is asking "Edit Permission". when click on this button. i got above code. i am trying to change with my localhost SQL Server. while doing this process i am getting error.

 

How overcome this situation, i don't understand...

 

Pls help on this....

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi venug20,

 

If you want to change the data source to a new Server, the new data source should have the same tables as the old ones (mainly the same structure.)  

As we can see from the error message, you localhost SQL Server doesn't have a column "IsCompete". Please check out. 

 

Best Regards,

Dale