Forum Discussion

VDubois's avatar
VDubois
Frequent Visitor
1 year ago

Dataflows Direct Query isn't working anymore since 144

Hi,

 

The version 144 introduced a bug while refreshing a dataset getitng data from Dataflows Gen 1:

Could not load file or assembly 'System.IdentityModel.Tokens.Jwt, Version=8.1.2

 

I installed the latest version 2.146.1026.0 that is supposed to fix this issue:

Changelog => 

  • Fixed DirectQuery failures for Gen1 Dataflows with Enhanced compute.

 

Still the same bug.... 

Could someone help or give a workaround?

Thanks !

18 Replies

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support

    Hi VDubois 

    Thanks for reaching out to the Microsoft fabric community forum. 

     

    I would also take a moment to thank Shahid12523  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

    The suggested workaround is uninstalling, rebooting, clearing cached credentials, and reinstalling the latest Power BI Desktop.

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

    Best Regards, 
    Community Support Team.

     

    • VDubois's avatar
      VDubois
      Frequent Visitor

      Thanks for your help.

      I have tried your workaround but the problem still persists.

      I hope Microsoft will quickly find a solution.

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support

        Hi VDubois   ,

         

        Since the issue still persists, this appears to be the known bug introduced in v144 affecting DirectQuery with Gen1 Dataflows.

        At this point, the best approach is to temporarily switch to Import mode until Microsoft provides a permanent fix.

        Best Regards, 
        Community Support Team

  • Royel's avatar
    Royel
    Icon for Super User rankSuper User

    Hi VDubois lets try some approach and see it work or not 

    1. Uninstall your current Power BI Desktop version.
    2. Restart your omputer. 
    3. Clear any cached credentials:
      - Windows Credential Manager → Remove all Power BI related entries from Windows Credentials
    4. Reinstall same Power BI Desktop (You have the latest version)
    5. Run Power BI Desktop as an Administrator (Solved 95% of JWT authentication issues)
    6. Check dataflow connection if failed 
    7. Try to switch Import Mode 

    Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

  • Shahid12523's avatar
    Shahid12523
    Icon for Community Champion rankCommunity Champion

    Power BI Desktop v144+ introduced a bug with Dataflows Gen1 DirectQuery (System.IdentityModel.Tokens.Jwt error).

    Even in the latest v2.146.1026.0, many still face it.
    Workaround:

    Uninstall → reboot → clear Power BI credentials → reinstall latest → run as Administrator.

    If still failing, use Import mode until Microsoft fully fixes it.

     

  • Hi VDubois ,

    This issue is known with recent Desktop versions. A couple of workarounds you can try:

    1. Update to the very latest Power BI Desktop (September 2025 or newer) – sometimes the Store/MSI builds lag in fixes.

    2. Clear the cache (File → Options → Data Load → Clear cache) and restart.

    3. If still failing, roll back to version 2.143 (June 2025) which doesn’t have the bug. You can download older builds here: Previous releases of Power BI Desktop.

    4. For Dataflows Gen1, consider testing Dataflows Gen2 if possible — this avoids many of the Gen1 limitations.

    Docs: Troubleshoot connecting to Power BI dataflows

    If this helps, please mark it as a solution
    — Nabha Ahmed (connect with me on https://www.linkedin.com/in/nabha-ahmed-166491221?utm_source=share&utm_campaign=share_via&utm_content=profile&utm_medium=ios_app ------

    https://medium.com/@nnooonani2015/my-journey-with-microsoft-fabric-why-i-recommend-joining-this-community-7c04e7bbe784)