Direct Query is disabled while changing data source

[Anonymous]

Hi, I am using SAP hana database to connect with my powerbi file and Powerbi Gateway also installed in my sytem. I am also able to publish my data and able to see on the web view. But problem is that if i want to change my IP for data source (database). Direct Query option is no longer available Please see the screen shot below:

Could you please help me on this? THanks.

[v-huizhn-msft]

Hi @Anonymous,

Based on my understanding, changing IP is unsupported in Direct Query mode as the error said. Please rveiew the limitations of Direct Query: All tables must come from a single database. You can recreate a new .pbix file and connect database using another IP.

Best Regards,
Angelia