Forum Discussion

Martin_Gebhartl's avatar
Martin_Gebhartl
New Contributor III
20 hours ago

Dimensions Descriptions via PowerBI connector

Hi,

does anyone know how to get the dimension descriptions (other then default) into PowerBI via the OneStream PowerBI Connector?

In the OneStream PowerBI Connector, there is the "Get Dimension" part with an "include descriptions" option but it only loads the default description (which is english in our setup). We have also a German culture setting and all descriptions are setup in English and German but I cannot find a possibility to get the German descriptions in PowerBI.

Regards
Martin

 

Reports
  • Martin_Gebhartl's avatar
    Martin_Gebhartl
    New Contributor III
    18 hours ago

    I was able to find a solution. I built a custom data adapter with an SQL rule, which joins the information of the member table with the member description table. This data adapter can be used in the PowerBI connector to get this information into PowerBI.

    Regards
    Martin