Forum Discussion
parameter in power query
i am running web query in power query in excel . it takes from - to time from excel cell and run the query .
is there any option in power bi that take input from text box and refresh web query using that .
and more over i dont find web data source in power bi web version
Hi vijaykaali811 -You can’t directly bind a slicer or text box input to a web query in M and refresh it dynamically without a full refresh.Unfortunately, Power BI Service does NOT support direct web queries using parameters unless the query and parameters are set up in Desktop first and refreshed via a gateway.
Hope the above details helps.
5 Replies
Hi vijaykaali811 -You can’t directly bind a slicer or text box input to a web query in M and refresh it dynamically without a full refresh.Unfortunately, Power BI Service does NOT support direct web queries using parameters unless the query and parameters are set up in Desktop first and refreshed via a gateway.
Hope the above details helps.
If you're creating a report form scratch in the service, only these data sources are supported. All others need the Desktop version
As rajendraongole1 mentioned, actions in the report (such as slicer selections) do not impact Power Query. It's the reverse. In DirectQuery, it is pseudo-possible—when a user interacts with the report (e.g., filtering, drilling down, selecting different values in slicers), Power BI generates SQL queries based on the DAX expressions in the report, sends them to the data source, and retrieves the result. However, these interactions do not affect any DirectQuery transformations made in the query editor
Hi vijaykaali811 ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Thank you rajendraongole1 and danextian for providing possible solutions. May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.Thank you.
Hi vijaykaali811 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi vijaykaali811 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
