Forum Discussion

JulBes's avatar
JulBes
Frequent Visitor
4 years ago
Solved

Error with Table.TransformColumnTypes function on SAP HANA DB

Hi, I have an DataSource on a SAP HANA DB with the DirectQuery mode. The Power Query running well on the Power BI Desktop June 2022 version. But since the last upgrade (July 2022 Version), the quer...
Need Help
  • JulBes's avatar
    JulBes
    4 years ago

    Hi,

    I note that the Problem doesn't appaers anymore with the Version : 2.108.997.0 64-bit (août 2022). Here is a test from the same Table/DB as my previous message.

     

     

    The conversion STRING -> INTEGER works:

     

     Does somebody know where is the correction documented?

     

    Thanks in Advance

    Regards

    Julien

     

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
4 years ago

In the list of Applied Steps on the right, please select steps previous to the TransformColumnTypes step and check for the First step returning that error.

  • JulBes's avatar
    JulBes
    Frequent Visitor
    4 years ago

    The previous step doesn't return that error.

     

     

     

    • ronrsnfld's avatar
      ronrsnfld
      Icon for Super User rankSuper User
      4 years ago

      Unfortunately, at this point, without sufficient data and code to reproduce the problem, I will not be able to help you further. Perhaps someone else can.  If not, perhaps you could create a file, with sensitive information removed, that will reproduce the problem (with data AND code) and upload it to some sharing site (eg OneDrive; DropBox) and then post a link here.

      • JulBes's avatar
        JulBes
        Frequent Visitor
        4 years ago

        I think that problem is linked with the source system SAP BW/4HANA.

         

        We could reproduice de Bug on our Sandbox System, here the step.

        Create an aDSO with 2 colums as following:

         

        With the "External SAP HANA View" Option, a Calculation View will be created on HANA DB

         

        Insert one "dummy" row with values 123 in both columns. Data Preview in BW4 look like this:

         

        In PowerBI Desktop:  import Data from the SAP HANA DB with the DirectQuery

        stsaphdb04.

         

        Select the column

         

        Data Preview in PowerQuery before the transformation

        Try to convert the NUMC type to Integer

        And then the bug