Forum Discussion
Paginated Report: Could not connect to data source
Paginated Report: Could not connect to data source there was error communicating with Analysis Services
Please verify that the data source is available and your credentials are correct. The connection either timed out or was lost.
this issue is only for few users even i tried to give them admin permissions in workspace, tried to refresh the dataset, redeployed the Paginated Report from the report builder etc etc but keep getting same error for few users.
Any idea what i scausing this issue.
Kind Regards
Mian
Hi Anonymous ,
Probable causes of this error are described in the documentation.Paginated reports time out after 600 seconds when using Power BI DirectQuery dataset as a source. After 600 seconds, you receive this error:
"There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. The connection either timed out or was lost."
For paginated reports running longer than 10 minutes, we recommend using the XMLA endpoint to connect to the Power BI dataset.
Please check.
Paginated reports in Power BIIf this doesn't work for you, please consider sharing more details about it.
Best Regards,
Community Support Team_GaoIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
2 Replies
Hi Anonymous ,
Probable causes of this error are described in the documentation.Paginated reports time out after 600 seconds when using Power BI DirectQuery dataset as a source. After 600 seconds, you receive this error:
"There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. The connection either timed out or was lost."
For paginated reports running longer than 10 minutes, we recommend using the XMLA endpoint to connect to the Power BI dataset.
Please check.
Paginated reports in Power BIIf this doesn't work for you, please consider sharing more details about it.
Best Regards,
Community Support Team_GaoIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data