Forum Discussion
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...
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.