cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tim-Brown
Frequent Visitor

Embedded Capacity with Shared PBI Dataset

Hello,

I'm currently working on a large project with a rather complex model. To help speed up development time I was hoping to be able to make edits to a single Power BI dataset while my co-worker works on a report that uses that dataset as its source. Ideally, we would have about five or six reports using this single "golden dataset."

The issue I have run into is that reports using a Power BI data set do not seem to work on our website, where they use embedded capacity. I cannot determine if this is a problem with our API or if shared datasets simply don't work on embedded? Documentation on DirectQuery for PBI datasets says that it is not supported for embedded capacity, but the documentation suggests that this sort of query is only used for composite models. It says that the connection to a PBI dataset uses "Live Connect."

Has anyone used a shared dataset on embedded?

Right now it pulls the error message "404 Not Found: Error while retrieving Embed URL
Not Found: {"error":{"code":"PowerBIEntityNotFound","pbi.error":{"code":"PowerBIEntityNotFound","parameters":{},"details":[],"exceptionCulprit":1}}}"

Barring the ability to use a shared dataset, is there a way to work on a PowerBI report as a shared dataset and then switch it over to its own import dataset? For example, getting rid of the PBI data source and copying and pasting in all the queries from the original dataset?

The shared dataset is really ideal because a lot of the work is in DAX and this would allow us to share measures and calculated tables/columns instead of copying and pasting them into new reports. The Dataflows allow the M side of the report to be shared but this is only half the word and the Dataflows run so incredibly slow they are almost unusable. 


Follow up question: If you have a very large shared dataset but a report only uses visuals from a small part of it, does the size still hurt embedded capacity usage when rendering visuals? It's too bad there isn't an option to truncate a model.

Thanks!




1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Tim-Brown ,

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:

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-troubleshoot#typical-errors-wh...

  • 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

https://community.powerbi.com/t5/Developer/Paginated-Reports-Embed-getting-error-quot-PowerBIEntityN...

https://community.powerbi.com/t5/Service/Some-of-the-powerBi-embeded-reports-returns-NotFound-404/m-...

 

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.

 

View solution in original post

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @Tim-Brown ,

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:

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-troubleshoot#typical-errors-wh...

  • 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

https://community.powerbi.com/t5/Developer/Paginated-Reports-Embed-getting-error-quot-PowerBIEntityN...

https://community.powerbi.com/t5/Service/Some-of-the-powerBi-embeded-reports-returns-NotFound-404/m-...

 

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.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

Power BI Dev Camp Session 25 with aka link 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, August 25 at 11a PDT for a great session with Ted Pattison!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors