Forum Discussion

Ganesh31's avatar
Ganesh31
Frequent Visitor
3 years ago

How change source from SQL (Direct Query) to Excel of a power bi Report

Hi Experts, I created a power bi report with sql as a source (direct Query) in which advance editor code is shown as below:   let Source = Sql.Databases("SCPHYDWLP00"), Plant = Source{[Name="Pla...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Ganesh31 , you have to do the reverse of what has been done here, but the steps are the same.

Change Connection from One source type to another Source Type: https://youtu.be/nwYJgG2hmd0

 

Mode need to changed to import