Unable to upload paginated report with OLE DB connection

[peju]

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

[v-lili6-msft]

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

[peju]

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

[v-lili6-msft · Accepted solution]

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. 

Best Regards,

Lin