cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
charliedata
Responsive Resident
Responsive Resident

Refresh suddenly failing

From nowhere, all sorts of problems with a dataset:

 

  • Won't refresh in Desktop - stuck at "Creating connections in model"
  • Won't refresh in Service
  • Can't even download from Service ("We couldn't export to .pbix format")

 

Error handling in Power BI seemingly could be handled better

 

The only idea I have is to try and rebuilt the PBIX one table at a time to see if there's one causing the problem. Painfully time consuming, likely inefficient.

 

Any other ideas on how to proceed?

 

 

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi  @charliedata ,

 

Refer if this can help - https://www.thebiccountant.com/speedperformance-aspects/

 

If you are on latest release then check any known issue -https://community.powerbi.com/t5/Issues/idb-p/Issues

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi  @charliedata ,

 

Refer if this can help - https://www.thebiccountant.com/speedperformance-aspects/

 

If you are on latest release then check any known issue -https://community.powerbi.com/t5/Issues/idb-p/Issues

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

GaryWalton
Frequent Visitor

Coming across the same / similar issue.

Applying changes (after leaving query editor) and refreshing individual tables does not respond with the normal list of events / actions:

Evaluating

Creating connections in model

###### records loaded from (source)

 

While testing on a smaller table, the data loads (both in refresh and applying changes after exiting query editor) but the notification never progresses past 'Creating connections in model', simply closes when complete.

 

The number of records loaded is important to see as it actually provides visual feedback, without it, MS will be inundated with complaints such as this.

 

I have only encountered this since the latest update.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors