Refresh table in power bi from source

Power BI
1

in power bi the source is a sql table. i.e. table1
inside the model of the power bi I change the name from table1 to Main
when the source changes, in power bi, I go to editor window, recent sources, click on the source name and then click on close and apply button. At this stage, table1 is loaded into power bi whereas I want the table Main to be updated instead.
Do you know why table Main is not updated whereas table1 with latest data gets loaded into the model instead?
thanks

2

@arkiboys
To update the table in Power BI to use the new name “Main”, you’ll need to update the query in the Power BI Query Editor. Here are the steps to follow:

  1. In Power BI, go to the “Transform Data” tab and click on “Query Editor”.
  2. In the Query Editor, find the query that is pulling data from the SQL table (it should have the name “table1”).
  3. Right-click on the query and select “Rename” to change the name to “Main”.
  4. With the query still selected, go to the “Home” tab and click on “Close & Apply” to apply the changes and load the updated data into Power BI.

Once you have updated the query to use the new table name, refreshing the data in Power BI should update the “Main” table with the latest data from the SQL table.

Let me know if that works for you. Thanks

3

Hello @arkiboys

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

4

thank you