Help needed with combining data from BI Service using Dataflow Gen2

[ho86]

Hi everyone,
I'm working on a model where I need to combine data from Excel, an on-prem SQL server, and Zoho Creator, with automatic refresh, to ultimately create Power BI reports. I prefer to use Power BI Service rather than Desktop to ensure the refresh is fully automated.
I’ve set up a workspace with Dataflow Gen2, and everything seems to be working fine. My question is how do I get the data into a report from here? Should I first publish the data from Dataflow Gen2 to a Datawarehouse? This approach seems to work, and I can see the tables, but when I try to create a report directly in the Datawarehouse, I encounter an error.
Is this the best way to go about it, or is there a more logical workflow for this?
Thanks!

Error:
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please check the technical details for more information. If you contact support, please provide these details.

Underlying Error: Capacity operation failed with error code CannotRetrieveModelException

[rajendraongole1]

Hi @ho86 - Might be the issue is with data connectivity, capacity limitations, or corrupted data models.

If you’re using Power BI Premium or Embedded capacity, this error may occur if the assigned capacity is either overloaded or has encountered an issue. You can monitor your capacity's health via the Capacity Metrics app in Power BI Service.

• Go to Settings > Admin Portal > Capacity settings and check whether your capacity is healthy or if it is under heavy load.
• If capacity is frequently maxing out, consider scaling up your capacity or optimizing the model.

If you are loading data from Dataflows (Gen2), double-check that the data has been successfully refreshed and the data model is intact.Test the connection by pulling the data into Power BI Desktop first. If the model loads successfully in Desktop, then the issue is more likely in Power BI Service.If it fails to load even in Power BI Desktop, the issue may be in the configuration of Dataflow Gen2 or the data model.Try optimizing the model by reducing the dataset size, removing unnecessary columns, or adjusting aggregation levels.

Use the Aggregations feature in Power BI to reduce the data model size for reports with very large datasets.

solved threads:

Solved: Capacity operation failed with error code CannotRe... - Microsoft Fabric Community

Solved: Re: BUG::semantic model inaccessible when creating... - Microsoft Fabric Community

[ho86]

Ok, is the step by pushing it to a datawarehouse needed? Is this setup logical?

I can't make reports directly from Dataflows (Gen2)? I use PowerBI Pro, not premium with a trial for the data storage. Can that be the issue?

[Anonymous]

Hi @ho86 

Pushing the data to a Data Warehouse is not strictly necessary in your setup unless you have specific needs for central storage or advanced data modeling. 

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.