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" 🤷

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

Thank you very much for your input.

I think we are very close to having this solved.

I've followed your steps above and it works out in the Power Query editor, (I can see the data load for the correct period).

However, when 'Close & Applying' it to the dashboard report, I run into this:

Once we have the above solved, I think I'll be all set.

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

Update to the above, I updated v-prasare query to show Period instead of @Period and the data loaded in the Power query editor ok. It also was closed and applied to the report but resulted in the same 'Conversion' error.

let
    Source = Sql.Database("MCMC.Server.com", "Database"),
    DynamicQuery = Value.NativeQuery(
        Source,
        "
        
            SELECT *
            FROM dbo.vPLGL_ISDashboard
            WHERE Period = Period
        ",
        [Period = fiscal_period]
    )
in
    DynamicQuery