cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sananthv
Helper II
Helper II

Power BI Premium Paginated Reports ODBC Support

Do we know when this will be available as some of the DB's we connect using SSRS onpremise is PostgreSQL.

8 REPLIES 8
v-yuta-msft
Community Support
Community Support

@sananthv ,

 

Have you installed Report Builder? In Report Builder, you can click data sourc type and select ODBC as below:

Capture.PNG 

You may also refer to this doc: https://docs.microsoft.com/en-us/power-bi/paginated-reports-quickstart-aw

 

Community Support Team _ Jimmy Tao

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

@v-yuta-msft  , thak you for the response. I was referring to the uploading of these reports to Power BI Service. 

 

PBI PAG Upload.png

@sananthv ,

 

I'm afraid currently power bi service don't support paginated report.

 

Community Support Team _ Jimmy Tao

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

hi Sanath,

 

We will look into adding ODBC support in a future update, no commitment yet. Have you looked into creating a Power BI dataset using PostgreSQL instance? If this dataset is on premium capacity, you can use RDL report connected to it through XMLA connection. https://powerbi.microsoft.com/en-us/blog/power-bi-open-platform-connectivity-with-xmla-endpoints-pub.... In Power BI Report Builder, when adding data source select "Microsoft SQL Server Analysis Services" as the provider. Thanks.

@rpatkar  Thank you for your reply. I am using Power BI Premium and since last Friday using Power BI dataset connected through XMLA. However the reason why I was asking whether Power BI Paginated reports will support ODBC is because there are a lot of SSRS reports connected to PostgreSQL through ODBC. The report pulls the data directly from the DB. I need the same when published to PBI Service. If I create an PBI ODBC custom connector with direct query, will it work when the paginated report connects to the PBI data set?

Anonymous
Not applicable

Hi,

 

Have you found a solution this ?

 

I am using ODBC connection  to a Oracle 11g in the SSRS report. I can open the rdl file in report builder but i dont see ODBC connection option in report builder 🙄

 

Regards,

Maddy

@Anonymous 

 

https://docs.microsoft.com/en-us/power-bi/paginated-reports-embedded-data-source supports Oracle.

 

PS: Sorry for the extremely late response 🙂

Team @v-yuta-msft 

 

Any update on this?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors