Read a value from power bi

[paocohe]

Hi everyone!

Is there a way to read a value enter in power bi and then do something with it using power query?

Thanks in advance 🙂

[v-xinruzhu-msft · Accepted solution]

Hi @paocohe 

In Power BI Desktop, it cannot support user input the value, you can create a table and input the value and then put the value to a slicer visual for user to choose. then if you want to edit the value at Power query, you can consider to use dynamic paramater in power query, but thr precondition is that the connection mode is direct query. You can refer to the following link about the dynamic paramater.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Unlock the power of dynamic parameter binding for ... - Microsoft Fabric Community

Best Regards!

Yolo Zhu

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

[shravanreddy133]

We'll need more context and examples mate.! The question is very vague.