cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
olimilo
Helper V
Helper V

[Report Builder] Could not connect to data source, connection time out or lost

I am using a Power BI dataset as the source of my paginated report on a premium workspace. Both the paginated report and PBI report are published in the same premium workspace. Currently, users of my paginated are getting the following error:

 

Could not connect to the data source.

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.

 

The topic below was the closest I could find on this. I did what the user suggested (to give Read and Build permissions to users I've shared the source report and paginated report with) however the users are still getting the error. Any other solutions I can look into to fix this?

https://community.powerbi.com/t5/Issues/Paginated-report-using-Power-BI-Dataset-reports-Analysis-Ser...

 

I also found this one but did not find any concrete solution from the Power BI team.

https://community.powerbi.com/t5/Desktop/Power-BI-Report-Builder-reporting-giving-error-There-was-an...

1 ACCEPTED SOLUTION

I took down the report and republished it again in the same workspace. You could try Allan's solution if it works; it doesn't for me because we were using a PBI dataset for the paginated report that had the issue.

View solution in original post

4 REPLIES 4
piyush_misra
Frequent Visitor

I tried downloading and refreshing on my PC (which was successful!) and then published. It still gave error refreshing it on the PBI service. So that did not work in my case specifically.

 

I then went into Settings-> Gateway connection on PBI Service. There the mapping of the Data Source was lost! Fixed that and refresh. Refresh went thru perfect!

simba2020
New Member

Hi, I am running into the same issue where the report works fine when running locally on the Power BI Report builder but getting the following when running on the Power BI Portal. What was the solution?

 

Could not connect to the data source.
There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid.
Activity ID: c2bcc975-9518-0119-ee25-4a5d6a9f6907
Request ID: c2bcc975-9518-0119-ee25-4a5d6a9f6907
Correlation ID: 32d749d37fe1477f887287fe44a7090a
Status code: 200
Time: Sat Mar 13 2021 10:45:44 GMT-0500 (Eastern Standard Time)
Cluster URI:  

I took down the report and republished it again in the same workspace. You could try Allan's solution if it works; it doesn't for me because we were using a PBI dataset for the paginated report that had the issue.

View solution in original post

v-alq-msft
Community Support
Community Support

Hi, @olimilo 

 

Please check if you have access to the data source with the same credentials. You may try to increase the 'CommandTimeout' and 'ConnectionTimeout' in 'Query Editor' to test if it works(Sql.Database ). Have you configure row-level-filter in Analysis Service? For further information, you may refer Implement row-level security in an Analysis Services tabular model . If it still doesn't work, I'd like to suggest you create a support ticket here .

 

Best Regards

Allan

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors