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.

 

Gross Sales = Calculate(SUM(vwNominalAnalysis[Total]),vwNominalAnalysis[NominalCode]="4000-04")

 

However, when I publish to the Power BI service, none of the measures work. I receive the error "This feature is not supported. Please make sure you have installed the latest version of the gateway." I have uninstalled and reinstalled the gateway several times with no luck.

 

The interesting thing is that when I create a report online using the dataset in the Power BI service, the measures work properly. 

 

I have tried endlessly to fix this issue, with no success. It seems as if when I apply any filter of type text in BI Desktop, it is causing an error in the Power BI service. A detailed example of the error is below.

 

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.

8 Replies

      • dti's avatar
        dti
        Frequent Visitor
        9 years ago

        I have narrowed it down further - I am using a slicer in my report. When I remove that slicer, all the measures work with no problems. Using direct query can you not use a slicer in parallell with measures?