Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I would like to build a Power BI report with a data source that has numbers as their name e.g. 25hourshotel
We have a database host selector and a database selector, so that we will only havbve to write the host and database in these fields and it will be automatically inserted in all queries, so thats what you see in the first screenshot.
In the second screenshot i tried to fill in the database name but the same error occurs.
Any ideas on how I can fix that?
Thanks for your help!
Solved! Go to Solution.
Hi @Anonymous
PostgreSQL table names should not start with a number.
If you have to work with tables that do, you can wrap the table name in double quotes
PostgreSQL SQL Syntax and Use | PostgreSQL Naming Rules | InformIT
Try this for your SELECT
"SELECT * from ""25hourshotel.25hourshotel.overview"""
Regards
Phil
Proud to be a Super User!
Hi @Anonymous
PostgreSQL table names should not start with a number.
If you have to work with tables that do, you can wrap the table name in double quotes
PostgreSQL SQL Syntax and Use | PostgreSQL Naming Rules | InformIT
Try this for your SELECT
"SELECT * from ""25hourshotel.25hourshotel.overview"""
Regards
Phil
Proud to be a Super User!
Hi Phil,
unfortunately I didn't create the data source and had to work with the number in the name. Anyway, I tried the double and triple quotes and they solved my problem, thanks!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |