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:
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.
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.