Question

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

2 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.

Hi Rai,

I and I am sure many others would appreciate an update on what you have done to get PowerBI working to a level it is genuinely useful. Like you I found the performance of the data ingestion to be painfully slow, prone to throwing errors and limited in the data retrievable.

Whilst the reporting capabilities within Creatio have improved, and will further when List object is available again, I cannot see it being a truly capable BI tool on its own data for some time yet. Especially when it comes to having mixed sourced data on the same page.

Thanks for sharing any useful information you may have.

Mark

Show all comments