Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
paocohe
Frequent Visitor

Read a value from power bi

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 🙂

1 ACCEPTED SOLUTION
v-xinruzhu-msft
Community Support
Community Support

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.

 

 

View solution in original post

2 REPLIES 2
v-xinruzhu-msft
Community Support
Community Support

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.

 

 

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

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors