Forum Discussion

Jackopoe's avatar
Jackopoe
Frequent Visitor
5 years ago

Connection Error in Paginated Report

Hi,

I have createed a paginated report with Report Builder.
The data source is Analysis Services. 
The report works fine when I run it from report builder, but when I publish it to Premium Capacity Area I get the following error:
"Cannot create a connection to data source"

I have tried fiddling with credentials but no luck.

Am I missing something?

 

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Is this an on-prem cube? If so, did you create the same connection on the gateway?  

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Jackopoe ,

     

    Try to give the users of your app "build" access to the underlying dataset.


    You can also refer to related blogs to see if it can provide useful information: [SOLVED] How to Diagnose and Get Rid of Power Connection Error In Paginated Report (avmajor.com)

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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