Refresh data gives blank values after appending queries

[HenkeC]

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 365.

-Combined two tables using "Append queries" into a new one and merged two different date-columns into a new column.

-I then uploaded the pbix-file online (Datasets >> Get Data >> Import or connect to data >> Files >> "My pbix-file")

-Set the data source credentials with the same Odata url and Authentication method: Oauth2

-I try to refresh the data and that's where the problem occurs.

It seems like my merged date-column is the main problem here. All other columns from the same "appended table" seem to work fine but my date-column is just showing blank. Everything else seem to refresh without problems.

Where would the problem be? I'm guessing it's the merge columns step that's messing things up so perhaps there's another/better way to combine the two date-columns and have it refresh correctly.

Everything seems to refresh as usual in Power BI desktop but the problem occurs when I try to refresh in Power BI services.

Any help is appreciated!

[Anonymous · Accepted solution]

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]

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

[Anonymous]

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