Forum Discussion

tmendoza's avatar
tmendoza
Icon for Resolver I rankResolver I
10 months ago
Solved

Dynamic M Query Parameters not working when I make slicer selection

You folks have always been a great help to me.  What am I doing wrong with my Dynamic M Query Parameter set up? I'm trying to speed up my Direct Query by utilizing Dynamic M Query Parameters. I fo...
Need Help
  • parry2k's avatar
    parry2k
    9 months ago

    tmendoza For everyone, it is fixed, and the solution was to remove "&" from the table name "P&L_GLDQ" 🤷

parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 months ago

tmendoza, there is no setting as such. I'm wondering if you run the query in the backend using SSMS or other tool with the same slicer value, does it work? I'm wondering if there is some issue at the source that the query is not returning the data. 

tmendoza's avatar
tmendoza
Icon for Resolver I rankResolver I
9 months ago

Just checked. Backend is working fine. The data is also returned at the power query editor level and report view. The break specificaly happens once a slicer selection is made using the bound parameter. From what I can see, I'm using the right format for it.

let
    Source = Sql.Database("ABCD.Server.com", "Database",
    [Query=
        "
        
            SELECT *
            FROM dbo.vPLGL_ISDashboard
            WHERE Period = " & Number.ToText(fiscal_period)]
    )
in
    Source