Forum Discussion

PowerBiNoobie1's avatar
PowerBiNoobie1
Helper I
5 years ago

PowerBI Errors pfoledbreader.cpp

Hi All   Seems like I am having fun with PowerBI. Seems like every day I have a new problem\error right now 😞   So my latest issue is when I change a measure to be a different value to SUM, say ...
Need Help
v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi PowerBiNoobie1 ,

 

Did you receive this error when you use SUM function?

What fields are in your visual?

Maybe you can create a card visual and put the measure in it, check what will happen.

 

There are some limitations in The CQD data model, you can refer this documents for comparison.

https://docs.microsoft.com/en-us/microsoftteams/cqd-power-bi-connector

 

Best regards,

 

Community Support Team _ zhenbw

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

  • PowerBiNoobie1's avatar
    PowerBiNoobie1
    Helper I
    5 years ago

    hi v-zhenbw-msft 

     

    OK so I have a card visual with the P50 Latency field in it, its a CQD measure. I am simply trying to change the summarisation to be average as I want to see the average latency for all calls made between two network points. I have page level filters creating the overall filter for the report which tells PowerBI to only filter for traffic between two specific network points and to report latency, jitter and packet loss for each call. I need PowerBI to return the average value of jitter, latency and packet loss for all calls that are returned by the page filter. I realise I am probably not doing this correctly!? 

     

    I cant create a query or manipulate the source dataset in PowerBI as nothing works at all after I do that. This has been reported as a bug by MS.

     

    Thanks

     

    Thanks for your reply 

    • PowerBiNoobie1's avatar
      PowerBiNoobie1
      Helper I
      5 years ago

      v-zhenbw-msft 

      I have since tried creating a new measure as below:

       

      AverageLatency = Average(Query1[P50 Latency])
       
      I tried adding that to the card visual and I get the same error. SQLDumper runs and then data cannot be displayed. The source data is a decimal value. I assume this is how I should be getting the average of the P50 Latency.
       
      Thanks!