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")
    )

     

     

aaa12's avatar
aaa12
Helper II
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 Team,

    Not sure if I can post my question here but its related to PowerBIIntegration.Data in powerapp.

    I have powerbi report in pbi desktop where I am pulling table list from excel file. Table list has Chnage Number as key field. I have used powerApp visual using Change Number from same tabel list. It navigated me to powerapp studio and I created form using same excel list as my data source. In that form ,I want record to be selected to update other fields related to selcted change number. For that I am using Lookup item using PowerBIIntegration.Data but its not populating any data.

     

    I am uisng below function in Item - LookUp('Manual3',Title=First(PowerBIIntegration.Data).Change Number) 

    Manual3 is datasource (online excel file) for form. After PowerBIIntegration.Data,its not populating any column in function.

     

    Not sure what I am misisng here. Error says Chnage number not valid/not found

     

     

    Can somebody please help me here. Really appreciate your input