Error: Couldn’t load the data for the visual: The query referenced a relationship between

[Anonymous]

Hi Forum,

I've developed a dashboard in powerbi desktop.

The data is in sharepoint online list. It refreshes in Desktop without any issue.

But when I publish, it doesnt refresh. ie doesnt refresh in powerbi service.

I get the below error:

**************************

Couldn’t load the data for the visual

The query referenced a relationship between Talk[Fall Date] and Calendar[Date], which depends on a column that is not in a valid state.

***************************

I used the Dax epression FORMAT in the Calendar[Date]. 

ie:

Calendar = CALENDAR( DATE(2016,01,01), DATE(2019,12,31))

Month = FORMAT( 'Calendar'[Date], "MMMM" )

Month Year = FORMAT( 'Calendar'[Date], "MMM, YY" )

Month Year Sort = FORMAT( 'Calendar'[Date], "YYYY-MM" )

Year = YEAR( 'Calendar'[Date] )

I've tried changing format in query editor but still get the error after publishing.

I also installed the latest powerbi desktop still no success.

Please Help

[v-frfei-msft]

Hi @Anonymous,

Based on my test, I created a Calendar table same as yours, and get date from SharePoint online list. However, I cannot reproduce you issue here. The visuals work well in desktop , report /dashboard in service. And all of them could be refreshed. Could please share the excel file containing data of the dataset and the M code in your power query to me?

Regards,

Frank

[Anonymous]

Hi  Frank,

Thanks for your time and  assistance.

This issue has persisted. It refreshes on desktop. I refreshed on Desktop this morning and no error..But tried refreshing after publishing and get the error:

Please what do you advice or suggest I do??

Delete Message

Back to Sent Messages

[Anonymous]

Hi  Frank,

Thanks for your time and  assistance.

This issue has persisted. It refreshes on desktop. I refreshed on Desktop this morning and no error..But tried refreshing after publishing and get the error:

Please what do you advice or suggest I do??

[RMV]

Hi @Anonymous,

have you got a resolution on your case? I face the same error message with you as a sudden, while it worked ok before.

Tried to check on the data type and relationships, but couldn't find what caused it happened, suddenly too.

tried to contacted the support for help, but they just pointed it back. bloody h*ll! 

[Anonymous · Accepted solution]

Hi RMV,

I contacted Microsoft support. I was persistent with  them  as I and all the contributors  cant find anything wrong with my Dax expression or calendar tab.

Eventually, they sent me zone switch m query which i updated at the query editor. 

I don't have that problem anymore.. Best is to contact Microsoft again and again.