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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

What version of SQL Server?

  • dti's avatar
    dti
    Frequent Visitor
    9 years ago

    2014 Express

    • 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?

      • dti's avatar
        dti
        Frequent Visitor
        9 years ago

        Another update:

         

        I have discovered that any time I filter, whether that is using a slicer or by any other visualization, the error is created in the Power BI service. Everything works fine in the Power BI desktop. I am wondering if it has something to do with the gateway and its interaction with SQL Server 2014 Express.