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
Did you refresh dataset on deployed workspace? New tables generated via DAX require refresh after deployment.
If you did refresh dataset, could you share DAX used for generating table and measure?
Cheers,
Nemanja
Hello nandic ,
Yes, I refreshed the dataset several times and it always ended successfully.
My bad, the code was not in DAX but in Power Query. It is a basic formula that creates a table with a timestamp as only value. Here it is :
let
Source = DateTime.LocalNow(),
#"Converted to Table" = #table(1, {{Source}}),
#"Extracted Day" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type datetimezone}}),
#"Renamed Columns" = Table.RenameColumns(#"Extracted Day",{{"Column1", "Last Refresh Time"}})
in
#"Renamed Columns"
Thank you in advance for your answer,
Zacharie