How I can change the origin database from Excel to SQL?

[allsmartperu]

Dear community:

I have this issue in Power bi. Before when I changed database origin wasn't difficult when they wre excel and I copy and paste the logic according to the rows that I wanted to change. But Now I have a problem changing the database origin because this is from SQL server. So this is my report:

This is my data base when I enter in advance editor 

And I want to change with this data base 

I tried to copy the 2 first row of the second image and paste in the first imagen but it doesn't work becase show the following error:

If someone wants to help me I'll appreciate. Or if there is other way to change database origin I 

[parry2k]

@allsmartperu do this:

Step 1 - copy 2 lines after Let from SQL based query

Step 2 - remove 1st 3 lines after Let in the current Excel-based query and replace it with 2 lines in step 1

Step 3- in Line 4, change this text #"Encabezados promovidos" to dbo_CPP_REPORTE

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.