count inconsistent

[realavaloro]

Hi,

I am using the PowerBI API to create datset, tables and rows. It's all good with the API.

However I am finding many inconsistencies when interacting with my dataset and tiles using aggregates like Count.

Scenario:

I have submitted around 45 records in a table called FS_declarations in my dataset and no more rows are being added after that, so the dataset doesn't change.

1-I want to see the total amount of records so I create a tile by entering the following text: "number of declarations" the result shows 10 which is not correct.

2-If I type an extra space at the end of my query, example: "number of declarations " the count updates to 45, which might be correct.

3 - If I then try to add this tile to my dashboard, in the preview the count changes again. This time it shows 20 but SOMETIMES THE NUMBER VARIES. See the inconsistency below for the very same query.

4-After adding it to my dashboard the number is different

I am unaware of the logic to calculate these results, but I suspect there are inconsistencies which doesn't make it very trustworthy.

Is there any way to view ALL the records (rows) a table has?

Any advice on this will be greatly appreciated.

[realavaloro]

does anybody monitor these forums?

[Seth_C_Bauer · Accepted solution]

@realavaloro I'm not to familiar with the API's, so bare with me. Your question (besides the anomolies in Q&A) seems to revolve around visuals. I'm assuming with an API you pull in a dataset, and you have the option to work with the data in the report section? There is a table visual that you can use to inspect your data (provided the previous assumptions are correct)

Otherwise, if you are relegated to "only Q&A" try different variations of "Show FS_Declarations in Table" or "Show count of FS_Declarations by (someField)" You can try to drive Q&A to display the visual you intend. Maybe that will help uncover a possible data anomoly? Outside of that, if you are sure the dataset is accurate, and there is no possible way the numbers can be achieved, i would submit a frown via the service or open a ticket via the support site here. Under "Contact Support"