Forum Discussion

allsmartperu's avatar
allsmartperu
New Member
4 years ago

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

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 

 

 

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    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.