Forum Discussion

HenkeC's avatar
HenkeC
Frequent Visitor
9 years ago
Solved

Refresh data gives blank values after appending queries

Here's what I've done so far:   -So basically I made my reports in Power bi desktop and then uploaded the reports online to Power BI services. -In Power BI desktop: I read the data from Dynamics 3...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi HenkeC,

    What is the data type and data format of the merged column? Create a new calculated new column using one of the following DAX formula based on your needs to merge the existing two date columns, then re-publish the Power BI Desktop to Service and check if refresh works as expected.

    Please replace column names with your owns in the following formulas.

    MergeColumn1 = CONCATENATE('Date'[Column1], 'Date'[Column2])
    MergeColumn2= CONCATENATE('Date'[Column1],CONCATENATE(",",'Date'[Column2]))

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi HenkeC,

What is the data type and data format of the merged column? Create a new calculated new column using one of the following DAX formula based on your needs to merge the existing two date columns, then re-publish the Power BI Desktop to Service and check if refresh works as expected.

Please replace column names with your owns in the following formulas.

MergeColumn1 = CONCATENATE('Date'[Column1], 'Date'[Column2])
MergeColumn2= CONCATENATE('Date'[Column1],CONCATENATE(",",'Date'[Column2]))

Thanks,
Lydia Zhang

HenkeC's avatar
HenkeC
Frequent Visitor
9 years ago

Thanks, that did the job! Everything seems to be refreshing normally now.