Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

0

Get CSV text file issue

Submitted by Anonymous on ‎11-23-2021 06:46 AM

Recently when i tried to execute Get File for CSV/Text file, it is stuck forever at establish a connection. What can be done to fix this ? This is the version i am using:

 

Version: 2.99.621.0 64-bit (November, 2021)

 

Status: Delivered

Seems like you have connected to multiple tables into one report under import mode which would cause the much longer loading time and even got stuck when you connect to new .csv files.

 

For import mode, upon load, all of the data defined by those queries will be imported into the Power BI cache. Too much large file would have lower performance like this issue, after you disable 'Enable load' for some tables, it got mitigated, that's an available way to optimize it.

 

About more options to optimize the data model and performance under import mode in Power BI, you can rerfer these articles and documents which would help you better:

  1. Data reduction techniques for Import modeling 
  2. Power BI Performance Optimization Tips 
  3. Import v Direct Query: Here's What You Need to Know 

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
3 Comments (3 New)
Comments
v-yingjl
Community Support
Community Support
‎11-23-2021 05:38 PM
Status changed to: Investigating

Could not reproduce it in my side as far as my test. When using the same version of Power BI Desktop to get text/csv file, it works fine.

 

Whether there is any screenshots about this issue? You can also consider:

  1. Whether the size of this file is too large to load into Power BI
  2. Try to open a new blank report to connect again
  3. Try to use the previous version of Power BI Desktop to check it again

 

Best Regards,
Community Support Team _ Yingjie Li

Anonymous
Not applicable
‎11-23-2021 09:00 PM

Thanks for the reply. I tried again to import the text file and it worked but today it seems to take longer to import. I have attached the screenshot of the message at the stage while waiting. This has been occuring after i disable "Enable loading" on tables. Could this be contributing to the issue? I have tried to import the same file on new blank page and it works fine. Wonder what could be wrong here ? or is it something i am doing wrong?

 

Screenshot 2021-11-24 125149.jpg 

v-yingjl
Community Support
Community Support
‎11-23-2021 11:18 PM
Status changed to: Delivered

Seems like you have connected to multiple tables into one report under import mode which would cause the much longer loading time and even got stuck when you connect to new .csv files.

 

For import mode, upon load, all of the data defined by those queries will be imported into the Power BI cache. Too much large file would have lower performance like this issue, after you disable 'Enable load' for some tables, it got mitigated, that's an available way to optimize it.

 

About more options to optimize the data model and performance under import mode in Power BI, you can rerfer these articles and documents which would help you better:

  1. Data reduction techniques for Import modeling 
  2. Power BI Performance Optimization Tips 
  3. Import v Direct Query: Here's What You Need to Know 

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses