Importing tables into Power BI

I need to import the tables into Power BI. I've tried using the 'Connector' and I've also tried using the API. And yes, I did everything according to the documentation.

 

When trying to use the 'Connector', I used the "Creatio.GetBigData" instruction, which according to the documentation is appropriate for obtaining large tables. However, it doesn't work, because it keeps giving me a credential error and constantly asking me to enter my credentials. And if my credentials are accepted, it takes many hours to import a table. This connector doesn't work at least for importing large tables. And let's face it, in 99% of cases the tables are large with much... much more than 20 thousand rows. In other words, this connector doesn't work for 99% of cases.

 

When trying to use the API, the same thing happens, because I can't import a table with more than 20 thousand records at once, and when trying to use pagination to import a few records at a time, the process takes me several hours to completely import a single table. This is not productive, it is tiring and takes up a lot of my time to do something that should be simple.

 

I am being charged to bring CRM data into Power BI, please can someone help me?

Like 0

Like

1 comments

Hi Raí,

The GetBigData and GetBigTopData functions were created as a workaround for the limitation of 20k records imposed by OData when attempting to download table data. The actual function used for data retrieval is GetData.


These functions enable you to download a snapshot of the table, bypassing the 20k record restriction. However, it's still necessary to apply a filter that ensures fewer than 20k records are retrieved in the process.

As a solution, we recommend using a regular database backup. After obtaining a copy of the database, you can restore it locally and configure Power BI to connect to this local DB copy. This approach will be much faster, more convenient, and ultimately easier for you.

Regarding the "credential error", I'd recommend you delete all connections from "Data source settings" menu. It might reset all previously entered credentials.

Show all comments