topic Re: Power BI Embedded - PosgreSQL - DirectQuery in Developer

Power BI Embedded - PosgreSQL - DirectQuery

kolousekjan — Mon, 15 Jul 2024 07:38:17 GMT

Hi,

Could someone please help me determine if what I want to do is possible?

I have a Power BI embedded report that I want to show to my customers. Each customer views the report through a filter, ensuring they only see their own data. The report connects via an on-premises gateway running on a VPS to a PostgreSQL database hosted on a different server.

My report operates in dual mode, but all connections to PostgreSQL are set up as direct queries.

The problem is that when I update something in the database, the changes do not reflect in the embedded report. Essentially, this solution is not working as expected.

Thank you.

Re: Power BI Embedded - PosgreSQL - DirectQuery

Anonymous — Tue, 16 Jul 2024 02:28:04 GMT

Hi @kolousekjan ,

You can consider using a tool like SQL profiler for PostgreSQL database to capture the query statements that Power BI sends to the data source when updating some content in the database, combined with RLS filtering, and then you can execute the captured SQL statements to the PostgreSQL database to check whether the returned data is updated. In addition, if you are updating a table imported from the database in import mode, the Power BI report will not be updated in real time until the next data refresh is successful.

ubiq.co

Using standard cloud based row-level security with embedded content in Power BI embedded analytics - Power BI | Microsoft Learn

Best Regards,

Liu Yang

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

Re: Power BI Embedded - PosgreSQL - DirectQuery

vladm-datanaut — Thu, 18 Jul 2024 14:49:09 GMT

Hey @kolousekjan ,

Power BI Embedded works with DQ connections. Have you enabled "change detection" on the pages where you use the DQ sources?

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

We use this with power bi embedded environments where we writeback from the app into the underlying DB and the changes reflect on the embedded report.

Cheers,
Vlad

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