Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unable to import complete data to Power BI

I am trying to import data to Power BI through ODBC connection to Dremio. I am using the web option in get data and passing the url as shown below********.com/api/v1/accounting/feeconversion?output=csv


 This is recorded as a ODBC connection to Dremio.


The dataset has around 5.6 million records. But every time I tried to import the dataset to Power BI, the ODBC connection to dremio terminates and returns exactly 1,147,806 records. 


I found the following information on Dremio

Input Bytes:1.06 GB
Input Records:1,180,942
Output Bytes:1.32 GB 
Output Records:1,147,806 


Is there some kind of limitations that is restricting the import?


PS - Dremio is a data-as-a-service platform that empowers users to discover, curate, accelerate, and share any data at any time, regardless of location, volume, or structure.


Thank you. 

Microsoft v-cherch-msft

Re: Unable to import complete data to Power BI

Hi @Anonymous


You may have a look at below posts.

For Desktop: 

For Service:




Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

Re: Unable to import complete data to Power BI

Hi @v-cherch-msft


Thank you for your response. 


For Desktop: 

The above scenario talks about importing the data using ODBC connectors. I do not have any difficulties importing the data using the ODBC connectors to connect to Dremio. 


But when I use the "Web" import option and pass the URL, that's when PBI terminates the connection to Dremio after importing only 1.1 million records of the total 5.5 million. 


So I was wondering if there is any limitations to the data imported when I use REST API which outputs the results as CSV.********.com/api/v1/accounting/feeconversion?output=csv


Since I am using output=csv in the URL, the call made to Dremio is an ODBC call, not a REST call. 


Thank you. 

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)