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

How to retain queried data?

Hi,

 

When I save the report as pbix file in Power BI Desktop, it always lose queried data.

If I open the saved file again, PBI says "There are pending changes in your queries that haven't been applied."

 

Then if save the file again, the same behaviour is reproduced.

 

Until desktop January version, I didn't experience this (now I'm using '18 August)

 

How can I solve this problem?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: How to retain queried data?

@v-qiuyu-msft

 

Hi, it seems that my company's DRM policy is the problem.

after amending the policy, now it works.

 

 

Thanks for your attention

View solution in original post

5 REPLIES 5
Highlighted
Frequent Visitor

Re: How to retain queried data?

Also, when I tried to edit queries, all the queries that refer to xlsx files showed an error at the source step.

 

 

DataFormat.Error: File contains corrupted data.
Details:
Binary

Highlighted
Community Support
Community Support

Re: How to retain queried data?

Hi @flavourabbit,

 

As the pbix file is fine in desktop January version, is there any change you made to the pbix file or source Excel file after updating desktop? 

 

The error "DataFormat.Error: File contains corrupted data." shows there is something wrong in source Excel file. Please go to Excel file check if any invalid data exist. Also you could use Excel connector in Power BI desktop to get data from the same table/sheet to see if it can retrieve data successfully. 

 

The message "There are pending changes in your queries that haven't been applied." prompts there are some changes made in Query Editor are not applied to data model, you can click Apply button in Query Editor to apply these changes. 

 

If the issue still exists, you can share pbix file and source Excel file with us. 

 

Best Regards,
Qiuyun Yu 

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

Re: How to retain queried data? - Status changed to: Needs Info

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

Re: How to retain queried data?

@v-qiuyu-msft

 

Hi, it seems that my company's DRM policy is the problem.

after amending the policy, now it works.

 

 

Thanks for your attention

View solution in original post

Highlighted
Community Support
Community Support

Re: How to retain queried data?

Hi @flavourabbit,

 

Glad to hear you find the cause. As the issue is resolved now, I will close this thread. 

 

Best Regards,
Qiuyun Yu 

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

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors