cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hanneke Frequent Visitor
Frequent Visitor

Data dissapearing after closing Query Editor

Hi all. 

I've made a connection with an Azure Data Lake Store to get some .csv files in Power BI desktop. When in the Query Editor, I see my data, but after 'Close & Apply', nothing is left. Most of my data turns into zero's (see screenshots). Some dates and text columns are preserved.

When going back to the query editor, the data is back again. 

I tried multiple things, connecting through multiple options and changing ALL columns to text type to see if the data remains. But nothing changes - when going back to the editor, the data is gone. 

 

Does anyone have an idea?

 

 

 data.jpg

no data.jpg

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Data dissapearing after closing Query Editor

@Hanneke,

What version of Power BI Desktop do you use? Please make sure that you use latest version of Power BI Desktop(2.62.5222.761).

Also please choose appropriate data type for your columns in query editor. I notice that you set the data type to decimal for some whole number columns, please change the data type of these columns to whole number and check if  the issue still occurs.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hanneke Frequent Visitor
Frequent Visitor

Re: Data dissapearing after closing Query Editor

@v-yuezhe-msft

 

Thankyou for your reply. I'm using the most recent version of Power BI Desktop, and also changing the data type doesn't fix the error. I've tried multiple things (setting it to whole number, setting it to text etc.).

Also, to make sure it is not due to login problems in ADLS for example, I logged out and in again in every service i'm using. Sadly, it didn't fix the error. 

 

Other suggestions are more than welcome.

 

Best, 

Hanneke

Moderator v-yuezhe-msft
Moderator

Re: Data dissapearing after closing Query Editor

@Hanneke,


Do you get this issue when connecting to local csv files? Is there any possibility that you can share me the csv file? I will test it in my Desktop.

Regards,
Lydia

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 54 members 1,166 guests
Please welcome our newest community members: