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

Unable to upload paginated report with OLE DB connection

Hi,

I have created an RDL report using Report Builder and have used OLE DB data source to connect to Azure Analysis Services.

It works when executed on desktop. When uploading the report to Power BI Service it fails with error:

 

Unable to upload paginated report
Report contains unsupported data source: DataSource2, of type: OLEDB.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 519c78df-6a3a-4ab9-a11d-8d316758e99f
Request ID: 2407a6d3-8e23-9475-6700-3a9cbd252543
Correlation ID: 24943442-9bc1-1657-9c01-44dfa268ce95
Status code: 400
Time: Tue Feb 26 2019 14:16:58 GMT+0100 (Central European Standard Time)
Version: 13.0.8482.125
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net

 

Is there a way to use data from Azure Analysis Services?

 

Thanks for reply.

 

Best regards,

Petr

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Unable to upload paginated report with OLE DB connection

hi, @peju 

For it is a preview feature, so "More data sources will be coming during the preview period." For your requirement, you could post your idea in Power BI ideas that power bi product team will accept it and make this feature coming sooner. 

And as a workaround, you could migrate data to Azure SQL Server during transition period. Smiley Happy

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Unable to upload paginated report with OLE DB connection

hi, @peju 

Currently, I'm afraid it couldn't achieve for now. 

Here are the data sources you can connect to for the initial release:

  • Azure SQL Database and Data Warehouse
  • SQL Server via a gateway
  • SQL Server Analysis Services via a gateway

More data sources will be coming during the preview period.

https://docs.microsoft.com/en-us/power-bi/paginated-reports-report-builder-power-bi

https://docs.microsoft.com/en-us/power-bi/paginated-reports-faq

 

Best Regards,

Lin

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

Re: Unable to upload paginated report with OLE DB connection

Hi,

 

is there any plan when and what sources will be available? I mean if I should wait for Azure Analysis Services source or e.g. migrate data to Azure SQL Server during transition period.

 

Thank you for reply.

 

Best regards,

Petr

Community Support Team
Community Support Team

Re: Unable to upload paginated report with OLE DB connection

hi, @peju 

For it is a preview feature, so "More data sources will be coming during the preview period." For your requirement, you could post your idea in Power BI ideas that power bi product team will accept it and make this feature coming sooner. 

And as a workaround, you could migrate data to Azure SQL Server during transition period. Smiley Happy

 

Best Regards,

Lin

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