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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi HenkeC,

      Glad to hear the issue is solved. You can accept helpful reply as answer, this way, other community members would easily find the answer when they get same issues.

      Thanks,
      Lydia Zhang