Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Strange dataflow issue

Good morning,   I have the following strange issue.  A customer has several workspaces with multiple dataflows for different purposes. All reports are build with a dynamic source query, showing a...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi Anonymous ,

     

    This is a known issue with the new Dataflow connector. These "phantom" dataflows are typically:
    Artifacts of deleted or corrupted dataflows
    Resulting from metadata inconsistencies or caching issues on Microsoft's backend
    Not fixed by workspace permissions or local refreshes.

     

    As of now, Microsoft has acknowledged the issue, and it has been discussed in community threads. However there is no official fix released yet. The issue still persists in recent versions.

     

    If this issue is affecting production workflows, we recommend opening a support ticket with Microsoft for dedicated assistance.

    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!

     

    Thnakyou.

grazitti_sapna's avatar
grazitti_sapna
Super User
1 year ago

Hi Anonymous ,


This action is currently a known issue with the new Dataflow connector in Power BI Desktop. The connector occasionally returns garbage or orphaned dataflow records (shown as null values such as "Database 12" and "Database 13") that no longer exist in the Power BI service. These null values appear when dataflows have been removed or where the connector's metadata is not refreshed correctly, even to users with complete admin privileges. While null filtering in your query is a good workaround, it's also a good idea to look for any Power BI Desktop updates or seek Microsoft support and community forums for a fix, as this is probably a bug that can be fixed in a future version.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Good day grazitti_sapna,

     

    Is there perhaps any news regarding this issue?

    Thanks in advance.

     

    Kind regards,

    Peter