Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Issue:
Power BI report view not displaying Table Visual, on onpremise report server when new tables or newly created columns are added/modified to the display.
Work Around: The only time it works (displays the table) is when I save the report as a NEW report on the server. This is not a reasonable solutions as I have to add all the permissions and data refresh schedule every time I make a change.
Steps to Reproduce: Put some data on Table visual -> Publish it on the On-prem Server -> Modify the Query by adding custom columns - > Add the column to Visual (Table) -> Save the report back on the Server (Overwrite)
Hi @ehsan4u,
Does this only happen to reports when you have scheduled refreshes set up?
We recently started to use scheduled refresh and noticed similar behaviour on our own deployed PBI reports in SSRS. What I think is happening is that when a scheduled refresh is added, a SQL agent job is created behind the scenes with whatever queries are needed for the PBI model to run at your specified frequency. If you update and redeploy the model, it doesn't automatically updated or recreate the scheduled refresh SQL agent job with the altered queries, added columns, or whatever changes you made.
You could try just removing and re-adding the scheduled refresh after you deploy changes to the PBI model to the server, instead of creating a whole new report and having to re-add the sql account permissions, etc.
That has worked for us.
Thanks,
-Jarret.