Forum Discussion
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?
2 Replies
- lbendlinSuper User
Is this an on-prem cube? If so, did you create the same connection on the gateway?
- v-henryk-mstfCommunity Support
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.