Forum Discussion

hensond2's avatar
hensond2
New Member
8 years ago

SAP BW and Power BI Connectivity

I am connecting to our SAP BW with the PowerBI Connector V1.  I can get to the InfoCube navigator and to one of our queries.  However, when I select a Dimension and Measure, I get a message in Preview mode that the Table is Empty.  I have input the required variables such as Company Code, Currency, etc.

 

Does anyone know why this would be?  I know this is an active query as I can access it and retrieve data via Analysis Addin tool through Excel.  Thanks for your help.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    hensond2,

    When you write MDX statement in Power BI Desktop, are you able to import this query?


    Regards,
    Lydia

    • hensond2's avatar
      hensond2
      New Member
      8 years ago

      Hi Lydia,  I have not written a MDX statement.  I will admit I am not a power user when it comes to something like this.  Could you suggest a basic MDX statement that I could potentially build from and try?  Thanks.