Forum Discussion
Advocate IPower BI - Unable to Render SSRS Report
I have imported a SSRS RDL file successfully into the Power BI Service and configured it to use the Power BI Gateway. The workspace is using Premium Capacity. We have other SSRS Reports successfully running in the Power BI Service.
When it comes to running this particular report within Power BI, it does not render. Apparently there seems to be an issue with one of the data sets in the SSRS Report. The SSRS report runs perfectly outside Power BI, but not within Power BI. The Query runs perfectly in Management Studio when I connect
There are no parameters, sub reports or drill downs. The Data sets are all connected to SSAS Cubes and running MDX Queries. The Data sources are all embeded (ie. not using shared data sources).
All gateway connections for the Data sources are set up and working for other native Power BI reports.
The Error messages is as below. Can anyone please assist?
Unable to render paginated report
Query execution failed for dataset 'WaitList_KPIs'.
Activity ID: 69526cfc-dd70-224a-83d9-8498a1704802
Request ID: 69526cfc-dd70-224a-83d9-8498a1704802
Correlation ID: 6c5399912ab548eb8fa8d30c17832b13
Status code: 200
Time: Thu May 23 2019 08:56:05 GMT+1000 (Australian Eastern Standard Time)
Cluster URI: https://australiasoutheast.pbidedicated.windows.net/webapi/capacities/74A90E50-BBDF-455E-9889-89135E552303/workloads/RsRdlEngine/rs/automatic/v1.0
G_R ,
Please refer to Frequency Q&A below:
What data sources do you support currently for paginated reports?
We support the following data source -
- Power BI Premium Datasets
- Azure Analysis Services (via single sign on (SSO))
- Azure SQL Database
- SQL Server*
- SQL Server Analysis Services (SSAS) tabular (DAX) and multidimensional (MDX) models*
- Oracle*
- Teradata*
- requires the on-premises Gateway.
When accessing SSAS through the Gateway, the user whose credentials are stored needs elevated permissions in SSAS to work through the Gateway.
Reference:
https://docs.microsoft.com/en-us/power-bi/paginated-reports-faq
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.
1 Reply
v-yuta-msftCommunity Support
G_R ,
Please refer to Frequency Q&A below:
What data sources do you support currently for paginated reports?
We support the following data source -
- Power BI Premium Datasets
- Azure Analysis Services (via single sign on (SSO))
- Azure SQL Database
- SQL Server*
- SQL Server Analysis Services (SSAS) tabular (DAX) and multidimensional (MDX) models*
- Oracle*
- Teradata*
- requires the on-premises Gateway.
When accessing SSAS through the Gateway, the user whose credentials are stored needs elevated permissions in SSAS to work through the Gateway.
Reference:
https://docs.microsoft.com/en-us/power-bi/paginated-reports-faq
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.