Forum Discussion

robm135's avatar
robm135
Icon for Helper I rankHelper I
5 years ago
Solved

Broken relationship after RS refresh

Hi I have an issue where resfreshing my data on Report Server breaks one of my datasets relationships to the date table.   The relationship is ok when refreshing the data in PowerBI desktop RS. Th...
Refreshing
relationships
  • robm135's avatar
    robm135
    5 years ago

    Here is my workaround:

     

    Originally my fact table date was a string like '2021-09-06T01:35:22Z'

    I would do a transform to date/time, then a transform to Date

    This was fine until Report Server did the refreshing 

     

    I've replcaed this double step with 

    Split '2021-09-06T01:35:22Z' by delmiter T, change to Date

    This now works when RS Server refreshes. 

     

    Using other Power Query transforms or functions to date only just didn't work. 

robm135's avatar
robm135
Icon for Helper I rankHelper I
5 years ago

Here is my workaround:

 

Originally my fact table date was a string like '2021-09-06T01:35:22Z'

I would do a transform to date/time, then a transform to Date

This was fine until Report Server did the refreshing 

 

I've replcaed this double step with 

Split '2021-09-06T01:35:22Z' by delmiter T, change to Date

This now works when RS Server refreshes. 

 

Using other Power Query transforms or functions to date only just didn't work.