Forum Discussion
Embedded Capacity with Shared PBI Dataset
Hi Anonymous ,
The shared dataset is the Live Connection connection mode. According to the research, the Live Connection connection mode cannot be converted to the Import connection mode. The size of the data also affects the use of embedded capacity.
Import models must be fully loaded into memory so they can be queried or refreshed. The Power BI service uses sophisticated algorithms to manage memory usage fairly, but in rare cases, the capacity can get overloaded if there are insufficient resources to meet customers' real-time demands. While it's possible for a capacity to store many import models in persistent storage (up to 100 TB per Premium capacity), not all the models necessarily reside in memory at the same time, otherwise their in-memory dataset size can easily exceed the capacity memory limit. Besides the memory required to load the datasets, additional memory is needed for execution of queries and refresh operations.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#how-capacities-function
According to the error it shows:
- Wrong Report ID
- Report doesn't exist
This is the related document, you can view this content:
https://community.powerbi.com/t5/Service/PowerBIEntityNotFound-Error/m-p/1218885
https://stackoverflow.com/questions/64109695/getting-powerbi-embed-token-403-forbidden
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
The shared dataset is the Live Connection connection mode. According to the research, the Live Connection connection mode cannot be converted to the Import connection mode. The size of the data also affects the use of embedded capacity.
Import models must be fully loaded into memory so they can be queried or refreshed. The Power BI service uses sophisticated algorithms to manage memory usage fairly, but in rare cases, the capacity can get overloaded if there are insufficient resources to meet customers' real-time demands. While it's possible for a capacity to store many import models in persistent storage (up to 100 TB per Premium capacity), not all the models necessarily reside in memory at the same time, otherwise their in-memory dataset size can easily exceed the capacity memory limit. Besides the memory required to load the datasets, additional memory is needed for execution of queries and refresh operations.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#how-capacities-function
According to the error it shows:
- Wrong Report ID
- Report doesn't exist
This is the related document, you can view this content:
https://community.powerbi.com/t5/Service/PowerBIEntityNotFound-Error/m-p/1218885
https://stackoverflow.com/questions/64109695/getting-powerbi-embed-token-403-forbidden
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the response. I have figured out what the problem was, it has to do with the way our specific website is built and we have resolved the issue.
I do still have a question vis-a-vis model size and shared datasets. For an easy example, let's say my 'golden' data set needs to have 20 tables and contains 9 million rows total. However, a given report built using that dataset only uses 5 of the tables, basically, one section of the model. Does being part of a larger model necissarily increase the resources needed to run the report, or is only the data needed to render the visuals called up?
We utilizie a lot of embedded links in our tables/matricies that filter our reports down to a small subset of our data on load. I was hoping this would reduce capacity issues.