From: Mauri Sahlberg <mos@iki.fi>
To: pgsql-admin@lists.postgresql.org
Subject: Re: RDS Postgresql 14.3 permission issue from powerBI
Date: Wed, 11 Jan 2023 19:50:17 +0200
Message-ID: <ed937182-1018-0aae-2254-4f7a328975c4@iki.fi> (raw)
In-Reply-To: <CALXoLqw_FOCzXxWHEPPKt=RwmYqpaT98WacNfkxk4WatcwqU3A@mail.gmail.com>
References: <CALXoLqw_FOCzXxWHEPPKt=RwmYqpaT98WacNfkxk4WatcwqU3A@mail.gmail.com>
Hi,
windows has two places for the odbc user and password when using power
BI. One is in the driver settings and one is in the power BI itself. Are
you sure you are using postgresql-user? As it is odbc-connection then
you probably have checked that the odbc driver is compatible with the
14.3 postgresql version and not an older or much newer one? Some of the
errors power BI gives can be a bit misleading in my experience, some
things are cached and errors can be hidden for quite a while and only
noticed when refresh is requested or something new is added. It might
even be possible to see almost correct database structure in the
navigator but when you try to access members of the tree then the
connection is actually attempted and something fails. For that regard
are you sure you should be using odbc-connection type and not something
else?
Regards,
Mauri
Ankur Kaushik kirjoitti 11.1.2023 klo 13.23:
> Postgresql version : 14.3 in RDS
> user : postgresql
> When I am trying to get the result from table from power BI getting
> below error, But I am using postgresql admin user.
> Also this user is working fine from pg client but not from power BI ?
> image.png
Attachments:
[image/png] image.png (631.6K, ../ed937182-1018-0aae-2254-4f7a328975c4@iki.fi/3-image.png)
download | view image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mos@iki.fi, pgsql-admin@lists.postgresql.org
Subject: Re: RDS Postgresql 14.3 permission issue from powerBI
In-Reply-To: <ed937182-1018-0aae-2254-4f7a328975c4@iki.fi>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox