Forum Discussion

aaa12's avatar
aaa12
Helper II
1 year ago
Solved

Getting Date Error in PowerBIIntegration

Hello, I embeded a PowerApp in my PowerBI dashboard. I am receiving the following error.   This only happens when there are null values in the Due_Date field. I tried creating another column...
Tips and Tricks
  • aaa12's avatar
    aaa12
    1 year ago

    I was able to resovle this. As inelegant as it is, I'm sharing the solution in case it helps others. 

     

    Basically, I created a measure to handle blank values and passed it through to power apps and it worked.

     

    m_DueDateText = 
VAR DueDateValue = MAX(dashboard[due_date])
RETURN
    IF (
        ISBLANK(DueDateValue),
        "",
        FORMAT(DueDateValue, "YYYY-MM-DD")
    )

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi aaa12 ,

 

Thanks for reaching out to this forum.

Did you get this error when you opened the dashboard on Power BI mobile apps? Is there an attempt to open it in Power BI Desktop or Power BI Service?

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

aaa12's avatar
aaa12
Helper II
1 year ago

hey stephen - yes, I get the error when I am in Power BI and launch Power Apps and submit data/request. I get the same error whether I open it in Power BI Desktop or PowerBI Services.