Forum Discussion

Kosenurm's avatar
Kosenurm
Regular Visitor
4 years ago
Solved

Most popular from Dataverse

Hi there,    I have a desk booking app, and the desks which have been booked are in a Dataverse table column.    I want to show a simple data card which counts the amount of times each individual...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Kosenurm 

    Step1: connect to dataverse in Power BI Desktop,

    Connect to Dataverse from Power BI Desktop

     

    Step2: After get data from dataverse, create measures like bellow( I create a sample for your reference, see file attached bellow)

    count = COUNT('Table'[desk])
    MaxCount =
VAR _count =
    MAXX ( 'Table', [count] )
VAR _name =
    CALCULATE ( MAX ( 'Table'[desk] ), FILTER ( 'Table', [count] = _count ) )
RETURN
    _name & UNICHAR ( 10 ) & _count

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Kosenurm's avatar
Kosenurm
Regular Visitor
4 years ago

Thanks, but when I do this, I get this error message - any ideas?

 

 

Error Message:
OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Input query length exceeding the supported maximum length.