Forum Discussion
user parameter in dynamic query
I think I got the syntax, but now I get the following error:
"Mixing DirectQuery and imported data is not supported."
Does that mean a parameter cannot be used for user input and passed to a dynamic query?
Or does anyone know how to get around this?
Many thanks!!
Hi raji,
Parameter is supported under Direct Query. Check:
Deep Dive into Query Parameters and Power BI Templates
This error “Mixing DirectQuery and imported data is not supported." Might be caused by the Parameter status, please right click the parameter, and uncheck the Enable Load option (If checked, after click close and apply, Power BI desktop would generate the error "Mixing DirectQuery and imported data is not supported."):
In addition, please take a notice of the data type of the data source and the parameter, make sure the type matches.
Please reply back if you need any further assistance on this.
Regards
Sorry for the delay - I was on business travel and wasn't able to check this... back now...
Looked at the link and I think I see the issue/disconnect now... I was looking for a query parameter that the user could enter and I could pass to the select statement to limit the rows returned (vs a slicer and filtering on it since the dataset is millions of records). However, using the link to query params and templates provided above, it looks like this is only possible using Desktop BI vs published reports that users are using.
If I misunderstood and there is a way to do this where the users can enter the parameter value from the report, would love to hear!
Thanks all for your feedback!!
Hi raji,
Currently I don't think this could be done under Report level with users.
Query Parameter is available ehn query the data, not after the query. If we would like to filter the report, we could add the slicer Visual. Which user could be able to select in Reports:
Regards
