Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Power Bi Report Tables Renamed

Hi,

 

I am very new to Power BI. I have question regarding reports.

I am using three tables to create my reports in Power BI. I almost created 8-9 sheets using those tables.

Now those tables are renamed in database. Now instead of old tables I need to use new one. Is there any way to achieve that.

Or I need to create the whole report again?

Thanks!

 

Regards,

Poonam

  • Hi patilpoonam21,

     

    No, you don't need to modify any page your report, not matter in import mode or in direct query mode. Click Query Editor-> Advanced Editor and modify TableName in M code which represent loading table in your three tables like this:

     

    Regards,

    Jimmy Tao

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Hi patilpoonam21,

     

    No, you don't need to modify any page your report, not matter in import mode or in direct query mode. Click Query Editor-> Advanced Editor and modify TableName in M code which represent loading table in your three tables like this:

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-yuta-msft,

       

      Thank you for your reply! It worked.

       

      Regards,

      Poonam