Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

What counts as a "record" when connecting external data source to Power BI via API?

Showing my lack of knowledge on this one...   I am working with a niche CRM vendor to provide a connection from their CRM system to Power BI via their API. However their developer is asking me this...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Anonymous,

    This is hard to describe, I think they should be distinguished by the Datasource connection mode and data store mode. 
    If you are trying to get data from a table that does not include any aggregation and dimension filed mappings. The total getting record amount should equal 'table row count' multiplied by 'refresh times'. 

    For the detailed trace and analysis, I think using 'query diagnostics' and 'database logs'(session logs and the query the API executed) should be more suitable for your requirement.

    Query Diagnostics - Power Query | Microsoft Docs

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI Anonymous,

This is hard to describe, I think they should be distinguished by the Datasource connection mode and data store mode. 
If you are trying to get data from a table that does not include any aggregation and dimension filed mappings. The total getting record amount should equal 'table row count' multiplied by 'refresh times'. 

For the detailed trace and analysis, I think using 'query diagnostics' and 'database logs'(session logs and the query the API executed) should be more suitable for your requirement.

Query Diagnostics - Power Query | Microsoft Docs

Regards,

Xiaoxin Sheng