Forum Discussion

heygau's avatar
heygau
Helper I
2 years ago

MOnday.com Data Extraction

I am working on Report part of the Data is from MOnday.com, i have got api but its all coming as one table. but it is grouped by Items on monday.com, Can someone Please explain how can I get it grouped by Items to Power BI. Thanks

Need Help
Tutorial Requests

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    heygau it is good you are getting row-level data, you can always visualize and group it by any column in your table. 

    • heygau's avatar
      heygau
      Helper I
      2 years ago

      Its just granualr Data, to group we may need to create group name Column. if we do that its not picking it up. Greoup name column coming out as empty because it is formula based 

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Well then that is a data source issue, you need to find out from monday.com how you can bring a formula-based column with the API. It has nothing to do with Power BI or you can use a similar formula to add a calculated column in Power BI to create this group column assuming you have all the values to create the formula.