Power BI NativeQuery - cannot convert from Type to Text

Question

I want to create two parameters Date from and Date to, and I want to write a query so I first created dates StartDate and EndDate and I am getting the following error

can't convert from data type Record to Text". Do you know what's wrong with it?

and I had a code

let
    Source = Sql.Database("Server\12", "Base1"),

        Query = Value.NativeQuery(
            Source, 
            [Query="EXEC [dbo].[sp_Sales] @DateFrom = '" & Date.ToText(StartDate) & "', @DateTo = '" & Date.ToText(EndDate) & "'"])
  
in  

 Query 

let
    Source = Sql.Database("Server\12", "Base1"),

        Query = Value.NativeQuery(
            Source, 
            [Query="EXEC [dbo].[sp_Sales] @DateFrom = """ & Date.ToText(StartDate) & """, @DateTo = """ & Date.ToText(EndDate) & """"])
  
in  

 Query 

Answer 1

• Create a parameter and import the data in Power Bi
• Create two parameters in Power Editor and mention the start date and end date by giving some default values

          

• Advance editor, give the following code

         let

    Source = Sql.Database("ServerName\12", "Base2"),
    Query = Value.NativeQuery(
            Source, 
            "EXEC [dbo].[storedProcedure_XYZ] @DateFrom = '" & Date.ToText(startDate) & "', @DateTo = '" & Date.ToText(endDate) & "'")
    
in
    
Query    

• Go to Transform data and edit parameters
• edit parameters

        

 If u want to learn more, come to this Power BI Certification.