Forum Discussion

andvpp's avatar
andvpp
Frequent Visitor
9 years ago

Query Parameters for dynamic change of PostgreSQL TABLE NAME

Hello,   In my company we use one database to store many tables. All tables have the same structure, only the Table Name changes.   We want to create a Power BI template in order to visualize ou...
Need Help
Tips and Tricks
Tutorial Requests
andvpp's avatar
andvpp
Frequent Visitor
9 years ago

Hello Xiaoxin Sheng,

 

Thank you for replying!

 

I am trying to use the function that you suggested. Here is a screenshot with the definition of the function in the Advanced Editor and the parameters I chose as an Input (Table "sales" in database "test_1"). I used a simple query to select all the columns in the table: "SELECT * FROM sales".


When I try to call the function using these parameters, I get an error: " Error in query « Requête1 ». Expression.Error : The key doesn't correspond to any of the lines inside the table. 
Détails :
    Key=Record
    Table=Table

 
Do you know what this error message means?

Andrea

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi andvpp,

 

You can use the get data to connect to PostgreSQL database. After finish connect, open the "Query Editor" and "Advanced Editor" to copy the paramters in the formula. Then input them to the custom function to test again.

 

In addition, I'm not recommend to use the "localhost" as the server name.

 

Regards,

Xiaoxin Sheng