Forum Discussion
Visual error on Power BI Service
Zacharie then big part of the issue is solved. Logic and M query are fine, it is working correctly when you create new report.
Next set of questions regarding report/layout 🙂
1) do you see this error on the report within workspace or within app? I suppose you already updated the app.
2) which visual are you using to show this measure? Is it default or some 3rd pary visual?
3) if this error is being displayed in report within workspace, and if in edit mode of report (on Power BI Service, not via desktop app) you remove this visual and just recreate it.. does it still shows same error? Based on previous answer, it should work fine
Zacharie i used M script that you provided, everything works fine.
It works in Power BI desktop app, works when i publish it, works when i deploy it (after refreshing it, before refresh it was empty).
So in no scenario i've seen error that you can see.
Additional checks:
1) go to your published dataset on deployed workspace: click on 3 dots beside dataset and choose option to create new report. Just drag and drop this "Last Refresh Time" field on the report to see if it will return error. If it returns error, then just try different M script.
Example:
let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in Source
2) check if this table for "Last Refresh Time" didn't accidentally create maybe relationship to some other table in the model which triggers this error
Cheers,
Nemanja
1) I tried and it was working as well, I really don't know...
2) I went on the semantic model and the table "Last Refresh Time" does not have any relationship with an other table in the semantic model.
Maybe it doesn't come from the semantic model itself but from the Power BI app that can't display the visual efficiently (for a reason that I can't imagine) ?
Thank you again for your help,
Zacharie
