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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors