Visual error on Power BI Service

[Zacharie]

Hello everyone, 

Recently, I deployed from test to production a semantic model and its report. It contained a new table to inform our users on the last time the report got refreshed (through a basic DAX measure). In test, the measure and the visual were working well, but now, in production, I have this error message.

Do you know where it comes from and how I can get rid of it please ?
I tried to contact the support but I was never able to send my error message... 

Thank you in advance ! 

[nandic]

Hi @Zacharie ,
Perfect, i am glad the issue has been solved.
We all learn 🙂

Cheers,
Nemanja

[nandic · Accepted solution]

@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]

hello @nandic , 

sorry for my late answer. 

My issue is solved. I did not know I had to update the PowerBI application... 

Thank you a lot for your help and your answers ! 

Zacharie 

[nandic]

@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

[Zacharie]

@nandic 

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

[nandic]

@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

[Zacharie]

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