missing rows in the tables connected to dataflow

[sanisin]

Hi , 

I'm experiencing an issue with missing rows from the Dataflow in Power BI. While the Dataflow contains all the rows, some are inexplicably missing when linked to Power BI Desktop or Power BI Service. Notably, Power BI was functioning well for at least six months. After re-updating credentials (with the same credentials), the issue was resolved for Power BI Desktop, but not for Power BI Service.

 the problem persisted for another colleague, and even after updating the credentials and refreshing the Power BI Desktop, the issue remained. However, he overcame it by copying and creating a new Dataflow, with no alterations from the original.Still not working for the power bi service 

Is this a known bug? Are there any workarounds or solutions available to address this issue?

[sanisin · Accepted solution]

@v-tianyich-msft  Thank you for investigating and sharing the related post. I've successfully implemented a workaround using a similar trigger. However, I consider this a temporary solution, as the current method seems somewhat distant from the ideal approach for triggering the flow to repopulate the tables. I'm uncertain whether I need to continually monitor for missing rows in the future and retrigger the process. This raises concerns about the credibility of my report.

[v-tianyich-msft]

Hi @sanisin ,

During my investigation I have found users in the past who have had similar experiences to you.

For original post, you may refer to:Solved: Re: Tables missing when connecting to dataflow fro... - Microsoft Fabric Community

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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