Forum Discussion
How to replace data in power bi
-Open your duplicated report in Power BI Desktop.
-Go to the "Home" tab and click on "Transform Data" to open Power Query Editor.
-Find the query that is currently fetching data for the "Open Inventory".
-Either modify this query to fetch "Closed Inventory" data (by changing the SQL query) or add a new query for the "Closed Inventory" if you plan to use both datasets in different visualizations.
-If you modify the existing query, make sure to adjust the table name or any filters in the SQL statement to fetch the "Closed Inventory".
-After modifying or adding your new query, click "Close & Apply" to update the report.
AmiraBedh thanks for your help
In this case what is hepping -
Acutlly For example- i have created open inventory dahsboard using SQL code , now i have duplicated the dashbord , in dupilcated dashbord still data is poining for open inventory, i want to change dupliacated dashbord for closed invontray data if i am chnaging data for duplicated dashbord even its chnaging for actul dashboard as well which i don't want. so acutual dashbord should be with open data and duplicated dashbord i should replace with new sql code which is closed inventory data.
-Open your duplicated report in Power BI Desktop.
-Go to the "Home" tab and click on "Transform Data" to open Power Query Editor.
-Find the query that is currently fetching data for the "Open Inventory".
-Either modify this query to fetch "Closed Inventory" data (by changing the SQL query) or add a new query for the "Closed Inventory" if you plan to use both datasets in different visualizations.
-If you modify the existing query, make sure to adjust the table name or any filters in the SQL statement to fetch the "Closed Inventory".
-After modifying or adding your new query, click "Close & Apply" to update the report.