Forum Discussion

dti's avatar
dti
Frequent Visitor
9 years ago
Solved

Power Bi Service Measures

I am creating a report in Power BI desktop and using various measures. All measures work appropriately on desktop. An example of one of the measures is shown below. It is a direct query to SQL server...
Need Help
  • dti's avatar
    dti
    9 years ago

    I was formatting a column in Direct Query as a decimal number. When I used this column in a slicer, it would cause my measures to stop working in the Power BI Service. Once I changed the column to type 'any', the measures worked. So yes, the problem was solved by changing the column type to 'any' from decimal number.

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

dti

 

I just test with latest PBI Desktop and get data from SQL Server 2016 in DirectQuery mode. The measure works well after I publish to PBI Service. I also have put text slicer in my report. It seems not to be related to SQL but related to gateway. Could you please check the on premise gateway status is good as below?

BTW, I’ve saw similar problem in other posts, and the problem is resolved by manually cleaning the registry of all PBI references after an uninstall, and then reinstalled the gateway. You can also have a try.

 

 

Best Regards,

Herbert

 

dti's avatar
dti
Frequent Visitor
9 years ago

I was formatting a column in Direct Query as a decimal number. When I used this column in a slicer, it would cause my measures to stop working in the Power BI Service. Once I changed the column to type 'any', the measures worked. So yes, the problem was solved by changing the column type to 'any' from decimal number.

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    dti

     

    It is good news that you’ve got it resolved. But it’s really strange, I also tried to add a decimal number column in my database and used it in a slicer. My measure is still working in the Power BI Service.

     

    Best Regards,

    Herbert

    • JDSX's avatar
      JDSX
      Frequent Visitor
      9 years ago

      Hi,

       

      My problem is somewhat similar but not enough that I could solve it same way. I added a measure which works in a KPI on desktop but not in cloud because it doesn't sync to the dataset. Measure is defined as:

       

      Active Companies = COUNTAX('Company', 'Company'[is_active] = TRUE())

       

      The error text is:

       

      Fields that need to be fixed
       
      Something's wrong with one or more fields: (Company) Active Companies
      Please try again later or contact support. If you contact support, please provide these details.

       

      Activity IDe83e5d04-9dfc-5bc0-52be-f69d33fe30da
      TimeSat Dec 17 2016 21:09:33 GMT-0500 (Eastern Standard Time)
      Correlation ID94d5f48a-4013-994e-e78c-61e1d7cbcd41
      Version13.0.1700.811
      Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net