Forum Discussion
While Scheduling the Power Bi reports in service facing error
EmailSubscriptionScreenshotVisualError
Visual errors were encountered while rendering the artifact. This subscription was delivered to recipients, however one or more visuals may be missing.
Error fetching data for this visual : A connection could not be made to the data source with the Name of '{"protocol":"analysis-services","address":{"server":"powerbi://api.powerbi.com/v1.0/myorg/BD%20SSBI%20DWaaS%20Core%20DS","database":"BD SSBI DWaaS Core Dataset"},"authentication":null,"query":null}'.
While Scheduling the Power Bi reports in service receing error as mentioned above .
Same time multiple persons schduled multiple reports is there any limitation in service @ all the users are having premium per user licence
Hi, naveenanda_vam
Thank you very much for the very useful information. I guess the cause of the problem lies on the visual querying data source. In the official Power BI documentation, it is mentioned:
Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn
When you try to subscribe for more than one person, the memory is exceeded. As far as we know, the content of a Power BI capacity isn't unlimited. Each license has a memory limit. A single person can't outdo it, and multiple people will send query requests to the data source in real time, which will consume exponential increments, causing us to quickly reach our limit.
Here's what we can do:
1. Try scheduling your subscription for a time period when no one is watching the report. Watching reports also requires memory that consumes your capacity for a live connection.
2. Try to reduce the number of people you subscribe to at a time, and don't add all of them to your subscription at once.
3. I think this one is the most user-friendly, try to group different groups of people, and then the important people will arrange the subscriptions individually. People who need to see the same content will only subscribe once and then forward an email to the group (or subscribe directly to the group).
The above method will be a good way to circumvent this limitation. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The EmailSubscriptionScreenshotVisualError happens when Power BI cannot connect to the data source while fetching data for a report. Possible causes include:
- Data Source Connection: Check if the dataset is connected properly, and ensure authentication is correct.
- Service Limits: Multiple simultaneous report schedules could overload the service. Consider spacing out schedules to avoid bottlenecks.
- Licensing: Premium Per User (PPU) should allow better performance, but still check for concurrency issues.
Solutions:
- Re-authenticate the data source.
- Check Power BI Service Status for disruptions.
- Try scheduling reports at different times.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
10 Replies
Yes given we have checked also its worked but today all are schudled same time for live. they received these kind of errors
- pallavi_r
Super User
Hi naveenanda_vam ,
Thanks for the input.
1. What is your data source?
2. Do you have gateway setup?
3. What is the connection mode - Direct, Live, Import?
Thanks,
Pallavi
Hi, naveenanda_vam
I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Best Regards
Jianpeng Li
Hi,
Greetings!!!
Last Friday we tried again but few reports are received as per the subcription raised , remaining subscriptions errors below
There was an error with your subscription "Construction KOP KPI Summary" but we still delivered it
You are receiving this email because there was an error with a subscription to Power BI Report "Company Practice KPI Summary" created by you.
EmailSubscriptionScreenshotVisualError
Visual errors were encountered while rendering the artifact. This subscription was delivered to recipients, however one or more visuals may be missing.
Resources Exceeded : The query has exceeded the available resources. Try filtering to decrease the amount of data requested.
More details : The XML for Analysis request timed out before it was completed. Timeout value: 225 sec.
You can check the latest state of the report by clicking in the button below.
Your next subscription is scheduled for December 20, 2024 13:30 UTC.
There was an error with your subscription "Business Plan vs Actual- By Month - Construction KOP" but we still delivered it
You are receiving this email because there was an error with a subscription to Power BI Report "Business Plan Vs Actual Summary" created by you.
EmailSubscriptionScreenshotVisualError
Visual errors were encountered while rendering the artifact. This subscription was delivered to recipients, however one or more visuals may be missing.
Error fetching data for this visual : A connection could not be made to the data source with the Name of '{"protocol":"analysis-services","address":{"server":"powerbi://api.powerbi.com/v1.0/myorg/BD%20SSBI%20DWaaS%20Core%20DS","database":"BD SSBI DWaaS Core Dataset"},"authentication":null,"query":null}'.
Resources Exceeded : The query has exceeded the available resources. Try filtering to decrease the amount of data requested.
More details : The XML for Analysis request timed out before it was completed. Timeout value: 225 sec.
You can check the latest state of the report by clicking in the button below.
Your next subscription is scheduled for December 20, 2024 13:30 UTC.
Technical Information
Activity Id: 3cd86020-94fe-49fe-bf82-d3ca6254cd80
Request Id: 75789511-45f1-452b-b67c-384f4cf5aa0e
Cluster Name: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Subscription Start Time: December 13, 2024 0:00 UTC
Subscription End Time: December 13, 2025 0:00 UTC
- Poojara_D12
The EmailSubscriptionScreenshotVisualError happens when Power BI cannot connect to the data source while fetching data for a report. Possible causes include:
- Data Source Connection: Check if the dataset is connected properly, and ensure authentication is correct.
- Service Limits: Multiple simultaneous report schedules could overload the service. Consider spacing out schedules to avoid bottlenecks.
- Licensing: Premium Per User (PPU) should allow better performance, but still check for concurrency issues.
Solutions:
- Re-authenticate the data source.
- Check Power BI Service Status for disruptions.
- Try scheduling reports at different times.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS - pallavi_r
Hi naveenanda_vam ,
This seems like authentication issue. Are all the recipients in subscription are given right permission with workspace or semantic model to view the report?
Thanks,
Pallavi
Thank you pallavi_r
Hi, naveenanda_vam
Will you be able to check if your reporting data source has a gateway connection configured?
Follow the image above to make sure you've configured your credentials correctly, and then try to resend the subscription:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
