Forum Discussion

Apostolakis's avatar
Apostolakis
Regular Visitor
1 year ago
Solved

Value cannot be null. Parameter name: Non-null assertion failure: queryName

Hello, I have the following message when I want to connect to SAP HANA database in DirectQuery since we upgraded Power BI Desktop. The last version without error message is 2.131.1203 (July 2024) ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Apostolakis ,

     

    We have seen on the internal platform that other engineers have reported this issue and submitted it.
    The engineers on the product team are now aware and will do their best to resolve the issue.This is currently an issue that will be fixed in November, and I'll update here with the latest news.

     

    Best regards.
    Community Support Team_Scott Chang

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi Apostolakis - you mentioned trying this already, ensure that all temporary files and related configuration files have been thoroughly cleared. Sometimes, Power BI Desktop might retain outdated configurations that could be causing the issue.

This could be a bug introduced in the newer versions of Power BI. Reporting it via the "Report this issue" button (as seen in your screenshot) or through Microsoft's support channels may help expedite a fix in future releases.

that your SAP HANA drivers and Power BI Desktop are fully compatible with the newer versions. Sometimes, issues like these arise due to outdated or incompatible drivers.

Since the issue is not present in the July 2024 version, you might want to stick to this version for now, and below is the power bi desktop application link FYR. especially if SAP HANA integration is critical to your operations. It may also be worth checking the release notes of newer updates to see if the bug is addressed in later versions.

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

 

Hope this helps.