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