cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jammy Frequent Visitor
Frequent Visitor

Do Power BI report server support OLE DB driver?

As the title described, if we defined Power BI desktop that loads the data source from OLE DB driver, will it able to publish to BI report server (on-premise) and share the web portal to each web users?

Additionally, I noticed the Power BI desktop version and report builder are similar, but the report builder has just subset of BI desktop version's functionalities. So will the functionalities in report manager be ONLY supported in Power BI Report server? what’s propose for each ones?

4 REPLIES 4
Moderator v-qiuyu-msft
Moderator

Re: Do Power BI report server support OLE DB driver?

Hi @jammy,

 

Power BI report server currently only supports live connection to Analysis Services (tabular or multidimensional). OLEDB is not supported now. See: Connecting to data sources. Publishing PBIX reports from Desktop will require a Pro License for production usage.

 

We can install Power BI Desktop optimized for Power BI Report Server. This is a different release from the Power BI Desktop that is used with the Power BI service. It's used to create pbix file, while report builder is used to create rdl files. You can learn more about Power BI desktop from below links:

Install Power BI Desktop optimized for Power BI Report Server

Getting Started With Power BI Desktop

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jpleed3 Frequent Visitor
Frequent Visitor

Re: Do Power BI report server support OLE DB driver?

Is there an approximate timeframe for when Power BI Report Server will be able to connect to a relational data source through OLE DB or otherwise? We have a project that we'd like to use Power BI Desktop for, but we would need to be able to publish it to RS using a SQL data source.

Moderator v-qiuyu-msft
Moderator

Re: Do Power BI report server support OLE DB driver?

Hi @jpleed3,

 

Currently there is no road map about other data sources. You can keep an eye on those two documents to get latest information.

Power BI Report Server release notes

Connecting to data sources

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
xantari Regular Visitor
Regular Visitor

Re: Do Power BI report server support OLE DB driver?

It appears the October update supports lots of data sources:

 

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources