Forum Discussion

Vikastandon's avatar
Vikastandon
Regular Visitor
2 years ago

Power Bi Report builder - Query Parameters error

I am using Power BI report builder, and have a data source: Ms Dataverse.

Created a simple SQL query to build Dataset (without Query parameter) - WORKS

 

Now i Edit the data set Query and add a where clause with the column = 'valuexyx' , CLICK ok  -WORKS

 

Next, I tried the add a Parameter and replace the value  column = @pmValue CLICK ok  - popup "Define Query Parameters"

Error-  Could not update a list of Fields for the Query. Verify you are connected to the data source

 

 

Executed (Run) the report 

 

 

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Vikastandon ,

     

    Thank you for your question. Depending on the information you provide, Sometimes, the connection may be lost or interrupted, which could cause the error you are seeing. Ensure that you are still connected to the data source.

     

    Whether you have multiple data sources, If so, I recommend you to read this article:

    [46e5-f09b-1f7-e12a] (microsoft.com)

     

     

    Best Regards,

    Yifan Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.