Forum Discussion

GuilhermeHerker's avatar
GuilhermeHerker
Regular Visitor
2 years ago

Embedded Report not refreshing with new data, but dataflow is refreshing correctly

Hello Community

 

I am having an issue with my PowerBi report and looking for some guidance.

 

My current architecture

I have a multi-tenant SaaS, and my db is Mongodb, using on-premises gateway to ingest data via dataflow. Built my dashboard on Powerbi desktop and published it and embedded it on my SaaS

 

It was all working nicely, but suddenly the data stopped refreshing.

I don't have any errors or logs about what is going on

 

the data flow is refreshing correctly every day and no errors or warnings are appearing.

 

How can I solve this?

 

Dataflow
Need Help

3 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    2 years ago

    Hey GuilhermeHerker ,

     

    refreshing the dataflow does not refresh dependent semantic models. Maybe this might be the reason. You can use a Power automate "job" to trigger a semantic model refresh when the dataflow refresh is finished.

     

    Regards,

    Tom

  • GuilhermeHerker's avatar
    GuilhermeHerker
    Regular Visitor
    2 years ago

    I used some tools to clean my powerbi file, but on the cloud, I still getting this when trying to update the semantic model.

    So to autorefresh my embedded power bi automatically I have to refresh my dataflow and the semantic model?

     

    super frustrating, it was all working when it was the trial period, but now that we are paying we have all sorts of errors, and my database isn't that big, we are a small SAAS with a couple of clients

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi GuilhermeHerker 

     

    Thanks for the reply from TomMartens , please allow me to provide another insight:

    This code means that your dataset has exceeded the effective memory limit, maybe you can consider these workaround:

    1. Upgrade to a larger Premium capacity (SKU) size for the semantic model.

    2. Reduce the memory footprint of your semantic model by limiting the amount of data loaded with each refresh.

    3. For refresh operations through the XMLA endpoint, reduce the number of partitions being processed in parallel. Too many partitions being processed in parallel with a single command can exceed the effective memory limit.

     

    Here are links for your reference:

    Resource governing command memory limit in Premium

    Move your Power BI embedded analytics application to production - Power BI | Microsoft Learn

     

    Best Regards

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