Refresh PBIX file connecting to a different schema in a database

[Anonymous]

We are using Vertica Database ( which doesnt support database connection parameter ). 

I have a PBIX file using some tables from a database schema (say X) created in a database (say Database1) .  Now my requirement is to refresh the PBIX file from a different schema ( say Y) from the same database Database 1.

How can i achieve this ?

[amitchandak · Accepted solution]

@Anonymous , If you have given the connection name in connection details you can edit and do that.

Another option is open power query, right-click on table open advance editor and change it there

refer my video : https://www.youtube.com/watch?v=59PUFuuCrbY

[Anonymous]

Thank you @amitchandak !!