Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sthomas2010
Frequent Visitor

Apply Changes Crashes

I have created a powerBI file that was access my Quickbooks Desktop data through CData but our accounting moved to another server that is hosted by another company and they do not allow cData as an application to be installed on their servers.  They use another application QODBC Desktop Driver for QuickBooks USA 2023.  So now I am having to go in and reconnect all my paths to utilize this new source and inevitably QODBC brings in a lot more data points and gives them different names.  I have tried to go in and fix all the different Queries I have (around 39) but how do I just apply changes to one querie at a time?  The data is so large that it crashes when it tries to apply all the changes.

 

Please do not tell me I have to completely recreate powerBi file because the one I have (with all the added formulas and Measures to analyze our accounting data took me a year and a half to create.  I am needing this data before the end of the month.

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

Hi @sthomas2010 ,

Please try below steps:

1. Please apply some filter when configure the connection to QuickBooks

2. Please apply the changes in steps

3. Please set the "Evaluation configuration settings" in Power BI Desktop, please refer: Evaluation configuration settings for Desktop - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

amitchandak
Super User
Super User

@sthomas2010 , If power bi file is too big, then you should prefer to commit changes one by one. We usually try to limit data on desktop

There is a video from Guyincube for that

https://www.youtube.com/watch?v=_zYvybVMk7k

 

 

You can also check quickbook power bi connector

https://amitchandak.medium.com/power-bi-a-quick-trick-in-case-the-quickbooks-connector-does-not-give...

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.