Multiple Schemas in a single report

[kabra_ashish]

I am looking to import tables from multiple schemas (same databsase) into a single report.

Example: Table_1 from Schema_1, Table_2 from Schema_2

My datasource is PostGRESQL database.

Challenge is it only allows to connect to 1 schema and import that table. When I try to import from the other schema (again the same database) I have to edit permissions and then able to import the 2nd but then the table imported from schema 1 throws an error because permissions were edited.

Any turnaround here?

[amitchandak]

@kabra_ashish , Check if you add them as queries using schema name in the table. Option to give query in advanced options 

[kabra_ashish]

@amitchandak I tried using Blank query option and it still doesn't work. I missed saying that every schema has credentials.

So when I try using PosrGRESQL or blank query it prompts for username and password. Ther server name and Database is the same but username and password is seperate for each and every schema created in the database.

So when I import from 1 schema and then try to import using the other it prompts for the credentials and the imports the same. But then the 1st schema imported thors and error.

[v-rzhou-msft]

Hi @kabra_ashish ,

Do you want to import multiple tables from same PostGRESQL Database? If your tables are from same database I they should need the same credentials. Can you see different tables in Navigator when you connect to database?

I think you can multiple select the tables you need.

Here is an offical blog about how to connect to PostgreSQL. I hope it could help you solve your problem.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.