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

Loading stuck

Hi,

 

I have a problem with loading data in one particular file. I have several tables loaded from Oracle server in DirectQuery mode and when I try to import anything - from simple excel file to another table from Oracle server I just get stuck in the loading screen.

 

When I open a new file and load the same data there it all works well.

 

In my main file, when I open Query Editor I see something like this:

tslowik131_0-1627571290278.png

 

I think this might me a problem, however, I have no idea how to fix it.

 

I would be grateful for any the help - unfortunetly I cannot delete the file and move onto the new one.

 

4 REPLIES 4
lbendlin
Super User
Super User

The exclamation marks indicate that loading of the preview for these queries has been interrupted (did you get impatient?).  Select each query one by one, and refresh its preview. After all are refreshed, make a small change somewhere and then close and apply.

I left refreshing for several hours and nothing has changed. Stuck as it previously was

Do you see the same issue when starting fresh (in a separate pbix), with just a single import table from Oracle?

Sorry, I forgot to answer.

No, the issue was only with this file. No matter what we tried the loading was always stuck. When we started a new file, imported one table, then next one, then next one - there was no problem.

In the end we just created a new file

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!