Paginated Reports - Data Source connection error

Hi,

I started working with the PowerBI Service and I seek for some advice for the following requirement.

Currently, I have paginated report built with the Report Builder which uses an ODBC connection to a PostgreSQL database. The report runs fine on a PowerBI Report Server.

Now I do want to use this report in PowerBI Service. In PowerBI Service I already have a PostgreSQL Connection on a Gateway I wanted to use instead of the ODBC connection – unfortunately without success (because “gateway connections are currently not supported” https://community.fabric.microsoft.com/t5/Desktop/Report-Builder-Connections-using-a-Power-BI-Gateway-are-not/td-p/4153086).

I created a semantic model for the PowerBI Service and tried to rebuild the paginated report using the online paginated report builder. This failed due to limited design possibilities and it seemed in general a bit buggy.

When I check the possible connection types in the “Add Data Source” I can select “Power BI semantic model” but unfortunately, I can’t establish a successful connection (Unable to connect to data source xxx. Please verify the connection properties, credentiuals, and all neede 64-bit versions od data providers are correctly installed).

• Is there probably an additional driver/library needed so I can successfully connect to a Power BI semantic model via Report Builder?
• Is there probably any other recommended approach or any other possibility to connect to a PostgreSQL database or a Semantic model in Power BI Service?

Any input/suggestion/ help is highly appreciated.

Many Thanks!