Able to update the existing SQL statement, you have to follow the below Steps :
You are Open to DashBoard Power BI Desktop
1- go to Query Editor Home>>Transform Data >> Transform Data
2- Open Query Setting On the Left side you will fine the query List, Select which one you want to edit
3- Open Query Setting On the Left side >> Query Setting >> Select the Source
4-Click on the Setting icon gear beside the Source to edit the Query Source
5-it will open SQL Server database settings would be shown, you can edit your SQL statement as you prefer
6- Then Close & Apply to effect on your Dashboard
No comments:
Post a Comment