Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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:
"How many records will be transferred each month from the CRM to Power BI?"
I have an email back to the developer for more clarity on this, but thought I would ask the community as well: What counts as a "record" in this context? A CRM system holds records of people's contacts...is that the meaning in this case? Or are we using database lingo here and I'm just in over my head?
Any insight here would be much appreciated, even if it's just something like, "only the developer will know for sure."
Thanks as always!
Solved! Go to Solution.
HI @kennedy311,
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
HI @kennedy311,
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |