Forum Discussion

Malo's avatar
Malo
Regular Visitor
4 years ago

Calculated column type mismatching in MS List automatic report

Dear All,

When I use "Integrate --> Power BI" feature in MS List web App, the type of a calculated column of the report, don't match the ones of the columns used in the formula. I've shared this problem with the MS List community, but they have confirmed it and don't have a solution. They have suggested me to talk about this issue in the Power BI community. Is There someone can help me?

 

Thanks for your Help  

Automatic report
calculated column
MS List
Need Help
Web App

5 Replies

    • Malo's avatar
      Malo
      Regular Visitor
      4 years ago

      Hi Anonymous,

      I've used both formulas below, with the same result

       

      =SUM([Column 1];[Column 2];[Column 3])

      =[Column 1]+[Column 2]+[Column 3]

       

      The field is calculated in MS List, when I create the report with List web app feature, I obtain a simple column, but with a wrong data type

       

      Regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        HI Malo,

        What data type of fields of the calculated fields? Did this issue only appear when you use the 'Integrate to power bi' features?

        If that is the case, you can try to get data and design the report on power bi desktop side, then publish to power is service side. It allows you to do operations on data models or shaping data structures.
        Regards,

        Xiaoxin Sheng