While Scheduling the Power Bi reports in service facing error

[naveenanda_vam]

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 

[v-jianpeng-msft · Accepted solution]

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.

[Poojara_D12 · Accepted solution]

Hi @naveenanda_vam 

The EmailSubscriptionScreenshotVisualError happens when Power BI cannot connect to the data source while fetching data for a report. Possible causes include:

1. Data Source Connection: Check if the dataset is connected properly, and ensure authentication is correct.
2. Service Limits: Multiple simultaneous report schedules could overload the service. Consider spacing out schedules to avoid bottlenecks.
3. 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 

[v-jianpeng-msft]

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.

[naveenanda_vam]

Yes given we have checked also its worked but today all are schudled same time for live. they received these kind of errors

[v-jianpeng-msft]

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

[naveenanda_vam]

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.

View content >

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.   View content >   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

[naveenanda_vam]

Adding to above errors these reports are working absolutely fine in Service and users acessing those with out any issue, but when we create bulk subscriptions with multiple reports and multiple filters with in reports we are facing above errors.

[v-jianpeng-msft]

Hi, @naveenanda_vam 

Merry Christmas to you. 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

[v-jianpeng-msft · Accepted solution]

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.

[pallavi_r]

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

[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