Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

SAP BW 'Scale Measures' error message when refreshing via PBI service

One of our connections is a direct connection to our SAP BW instance.  Several .pbix files have been written, published to the PBI service and are refreshing successfully via our on-premise Gateway. ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Anonymous,

 

Based on my test, the [ScaleMeasures=false] parameter appended in SapBusinessWarehouse.Cubes function automatically when get data from SAP BW in Power BI desktop August version.

 

I have sent a email to consult this issue internally, will update here if I get any information.

 

Best Regards,
QiuyunYu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Anonymous,

 

Please see below response from the PG team:

 

ScaleMeasures was added to (I think) the May 2017 release of Power BI desktop. It exists because of what seems to be a bug in either BW itself or in the driver we’re using to connect to it, and because we wanted not to change the behavior of preexisting queries. Setting it to false (the default is true) enables the workaround.

 

To make the gateway work, the customer should just need to update the gateway to the latest version.

 

Please keep the [ScaleMeasures=false] in your report,  try to download the latest on-premise data gateway to check if the refresh can be successfully.

 

Best Regards,
QiuyunYu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thank you for the feedback.  We installed our on-premise Gateway in May and have not updated it since.  I too thought that we should update it:

     

    A) Because it needs to be current version

    B) To test to see if this particular is resolved.

     

    I will do so and reply to the thread to close the loop.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hello,

       

      Did updating to the latest version help? We are in a similar situation and need to take a call on this. Awaiting your response :)

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi Anonymous,

       

      Any update about the issue? Is your issue solved now?

       

      Best Regards,
      QiuyunYu

      • BIfanatic's avatar
        BIfanatic
        Resolver I
        8 years ago

        We have an updated gateway, but this does not seem to resolve the issue. I experienced this problem today, unfortunately.