Forum Discussion

Regular Visitor

7 years ago

Something's wrong with one or more fields

I added a field to one of my Queries, and renamed a few columns in another one. It all works fine on my desktop, but when I publish it to PowerBI.com I'm seeing an error on affected reports sayi...

Super User

7 years ago

Thanks for letting me know.

Another question is the report using DirectQuery or is all the data being imported?

Regular Visitor

7 years ago

The report is using Direct Query. I have multiple tabs using Direct Query, some of which have no problems, some of which are exhibiting this behavior.

GilbertQ
Super User
7 years ago
Hi there

Can you confirm that you have the latest version of the On-Premise Data Gateway installed?

It appears that one of the columns in the table AllJobPerf is having an issue?
dar100111
Frequent Visitor
6 years ago
Hi, was this ever resolved on your end. I've seen a lot of issues regarding this now with no real solution. Our WSA's are logging support ticket with microsoft. We have an internal power bi server hosted and are not using cloud but Power BI Desktop (Optimized for Report Server) and this issue is becoming a huge pain for pbix templates that are updated daily. Our refreshed work fine, works fine on the server but this problem sticks around for several hours at times until it actually reckognizes the changes, even though there is nothing wrong with the report or refresh.
- Anonymous
  Not applicable
  6 years ago
  Hi,
  Sometimes when you change the DAX queries, unfortunately, the report in the server doesn't grab up those changes, even if you have saved it (overwriting it). It will work for a few minutes, and then later show the error which we are talking about.
  
  The workaround I found out was deleting the file in the server, and saving it in the same folder with the same name for that file after you are happy making the changes you have done to your pbix file.
  
  Thanks,
  Modasher.