Forum Discussion

keithpoplar's avatar
keithpoplar
Frequent Visitor
9 years ago
Solved

Dynamically change query parameter

1. Is it possible to change query parameter dynamically using REST API or URL query string? Because I am integrating Power BI report in my own application so this is important to me. I know I can pas...
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    keithpoplar There is Power BI REST APIs that you can use to automate certain tasks. Documentation for that is here and listed operations. I don't see anything for query parameters.

     

    There is Power BI Embedded which is Azure service. There are several REST operations available for that and can check them out here. Again no operation for query parameters I can see.

     

    Query parameters are currently only supported in power bi desktop and not in power bi service and that is why you don't see operations for them via APIs as well.

Markzolotoy's avatar
Markzolotoy
Impactful Individual
9 years ago

I am on exactly same journey trying to figure out how to make reports without data parameters. Can't really comprehend how to run SQL statements without parameters. One guy here recommended to get all the data into the report and then use a slicer. Forgot to tell him that I am querying Historiians with millions of records and even more.

SAG1's avatar
SAG1
Helper I
9 years ago

Markzolotoy were you able to find solution for this , please share if you have any info , I am pretty new to power bi and in same delima how can i enable user to change parameters give its huge database can not load all and everything .