Powerbi Pro Migration - Fabric Capacity Sizing?

[bsyed119]

Planning to move all existing powerbi Pro workspaces to Fabric capacity, most of reports using import mode connectivity due to different sources joining the data.   Want to do  lift and shift with out modification to reports, by just moving the license from powerbi pro to fabric capacity, before that need to choose the right fabric capacity and get the company budget approval, to calculate the capacity sizing, how to to check the  current pro workspaces total  memory usage?  so that i can choose the right capacity as mention in the link

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#semantic-model-sku-lim...

How to determine in fabric workspace required large or small semantic model format? what are other parmeters need to consider for fabric capacity sizing? 

[v-priyankata]

Hi @bsyed119 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @bsyed119 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @bsyed119 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[lbendlin · Accepted solution]

Want to do  lift and shift with out modification to reports, by just moving the license from powerbi pro to fabric capacity

You are slighly mixing concepts. Licenses are not part of this equation.

Did you have Power BI Premium capacities before?

In the Admin center you can assign workspaces to different capacities (also possible via API calls).  That includes movin Pro workspaces to Fabric capacities.

Plan your capacity size - Microsoft Fabric | Microsoft Learn

[bsyed119]

No we don't have premium capacity, it just pro .  it's move from pro workspace to fabric capacity workspace.    As we tried to migrate on of report in pro to fabric under F8 capacity, it got failed with  below message

• Data source errorResource Governing: This operation was canceled because there wasn't enough memory to finish running it. Either reduce the memory footprint of your dataset by doing things such as limiting the amount of imported data, or if using Power BI Premium, increase the memory of the Premium capacity where this dataset is hosted. More details: consumed memory 2979 MB, memory limit 2979 MB, database size before command execution 92 MB. See https://go.microsoft.com/fwlink/?linkid=2159753 to learn more.

so i what to analyse the  existing  pro workspace reporting memory usage before moving all the reports in fabric, any advise how to get the pro memory usage for the workspace?

[lbendlin]

You either need to consider a (much) bigger capacity or you need to do some refactoring on your data model so it desn't balloon so much when being decompressed.

How to get semantic model memory usage?  Nobody knows. Maybe try DAX Studio.