Forum Discussion

sb_powerbi's avatar
sb_powerbi
Icon for Helper II rankHelper II
9 years ago
Solved

Rename Database views already Mapped with Power BI direct Query Mode with out recreating measures

Hello , Please help me on the trick in Power BI Direct Quesry Mode.   I have created Power BI reports using Sql Server view with Direct Query mode. I am trying rename the View in Sql Server,but th...
Need Help
Tips and Tricks
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    sb_powerbi

     

    Hi,

     

    I have tested it. It worked great. If I use some name that doesn't match, only error message showed up. Do you mean "power query" is Query Editor? Did you change something else at the same time. Could you please post the error screenshot?

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

sb_powerbi

 

Hi,

 

You can change the source table or source view from Advanced Editor. Details are in the picture.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

sb_powerbi's avatar
sb_powerbi
Icon for Helper II rankHelper II
9 years ago

Thanks for the details, Is that method will work for direct query mode,because we have tried to edit in the power query. After the changes power bi asking to switch back to import mode.

 

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    sb_powerbi

     

    Hi,

     

    I have tested it. It worked great. If I use some name that doesn't match, only error message showed up. Do you mean "power query" is Query Editor? Did you change something else at the same time. Could you please post the error screenshot?

     

    Best Regards!

    Dale