Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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 BI
If this doesn't work for you, please consider sharing more details about it.
Best Regards,
Community Support Team_Gao
If 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
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 BI
If this doesn't work for you, please consider sharing more details about it.
Best Regards,
Community Support Team_Gao
If 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
solution accepted
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.