Forum Discussion

IamTDR's avatar
IamTDR
Icon for Responsive Resident rankResponsive Resident
3 years ago
Solved

BI Report Refreshes on Desktop / Error Refreshing in Service

Hello As the subject line states, I created a report via BI Desktop and when I publish the report to BI Service the report does not refresh. I am receiving a error message that I do not understan...
Need Help
  • IamTDR's avatar
    IamTDR
    3 years ago

    I just got my BI report to Refresh in BI Service.
    I think this must be a bug. 
    In my table, I used a transformation (Power Query) to sort by date.  By removing the Sort step the report was then able to refresh in Service.  (In reviewing, the Sort step wasn't actually needed)

    Not sure why Sorting caused this issue, but this was how I resolved my issue after many trial and errors.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Hi IamTDR 

 

The error is saying that there is an invalid column name 't0_0' which is coming from your table "Lookup_Rolling_Published_PubDat"

 

If you can please make sure that the gateway server can read the source SQL Server.

  • IamTDR's avatar
    IamTDR
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    Thanks for the reply. 
    This is the confusing part. No field in that table is named that. Actually the table listed is rather small. I even tried to do a test and remove said table but the refresh error still existed but then named another table. 

    Also noticed that Dashboards with tiles linked to this report I cannot even delete now. Very strange indeed. 

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      3 years ago

      Hi IamTDR 

       

      That is really weird what happens if you try it again?

       

      Also is it possible to monitor your SQL Server when it is refreshing to see what query is being sent?

      • IamTDR's avatar
        IamTDR
        Icon for Responsive Resident rankResponsive Resident
        3 years ago

        Tried multiple times during the day all the same results. Curious what happens after a refresh over night.