Forum Discussion

Cgilbert's avatar
Cgilbert
New Member
4 years ago

Refreshing data lead to Error message "object reference not set to an instance of an object"

Hello Everyone,
We have an issue with a PowerBI that we refresh every month and that is link to SAP with the SAP BW connector.
When we refresh the data this month we hve the error message "object reference not set to an instance of an object" and it never occurs before.

When i have a closer look at it, i found something strange. 
Itry to add the same connection to the same request and it works the first time but when i refresh the preview the error appears again.
Even more strange the error occur on the Navigation Step even if the object exist.

Do you have an idea of what could happened ?

Thank you in advance for your help.

Need Help

5 Replies

  • Cgilbert's avatar
    Cgilbert
    New Member
    4 years ago

    Hello vanessafvg ,

    Thank you for your response, as i have not administrator rigths on the laptop, i couldn't do these tests for now but i ask for and i am waiting for the team to give them to me.

    My PowerBI version is 2.105.1143.0

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      4 years ago

      it looks like you still on the may version and these updates were made in July so upgrading might resolve the issue

       

      July 2022 QFE 1

      Version: 2.107.841.0, Released: July 21, 2022

      Bug fixes/improvements:

      • Fix for SAP BW: now customers will be able to retrieve a full dataset when querying SAP BW and using paging operations (Table.skip, Table.FirstN etc) even if the data exceeds the page size.
      • Fix for SAP HANA: now when creating new connections or refreshing data, a display name will be shown instead of a technical column name in the fields well.
  • Cgilbert's avatar
    Cgilbert
    New Member
    4 years ago

    Hello,
    To keep you update for this issue:
    - I update my Power BI but it hasn't change anything

    - I did the trace in the link that vanessafvg provide and now before the error message we received, it appears there is something other occuring before because we receive this error message
    "SAP.Middleware.Connector.RfcInvalidParameterException: Element ET_DATA of container metadata RFC_READ_TABLE unknown"

    But we are still investigating one this one