Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
TuesdayApril
Helper I
Helper I

Semantic Layers in Power BI Embedded Workspace A1 Not Refreshing

We changed a workspace to Power BI Embedded and the semantic layers are not refreshing. A third party turned on the A1 embedded capacity. Not entirely sure the Azure AD process so they may have left something undone.

 

I do have XMLA endpoint enabled. We are in import mode for semantic layers.

All the semantic layers are under 1 gb limit pro licenses workspaces required. We are using semantic layers live connected to their reports.

 

I loaded a tiny 149mb semantic layer and it spins and spins.

 

Here is an example of the error:

 

1 ACCEPTED SOLUTION
TuesdayApril
Helper I
Helper I

I ended up taking the original workspace back to Pro licensing, elaving the semanti layer there, and copying the reports to an embedded workspace in A1.

 

Users beware semantic layers that run in an ordinary Workspace under 1gb may not be able to in an a1.

View solution in original post

4 REPLIES 4
TuesdayApril
Helper I
Helper I

I ended up taking the original workspace back to Pro licensing, elaving the semanti layer there, and copying the reports to an embedded workspace in A1.

 

Users beware semantic layers that run in an ordinary Workspace under 1gb may not be able to in an a1.

GilbertQ
Super User
Super User

Hi @TuesdayApril 

 

The reason this is happening is because when you turn on embedded capacity, you are limited in the amount of memory you can consume In your example above an A1 can only consume 3 gigs of memory. In your example, when you add up your consume memory, your memory limit and the database size before execution, it's over their 3 GB limit and that is why it is erroring out. What I would suggest is to remove the power behind bedded from your app workspace and everything should go back to normal.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Also, we want to use the Embedded workspace.

Does that 3gb act as a limit on each activity? If I set a semantic layer to only refresh on query at a time, shouldn't it come under 3gb?

 

power behind embedded? Lost me here.

Do you mean live connect reports from a semantic layer in another woskpace not embedded?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors