Problems when using relationships

[lmannear]

Hello everyone,

I am having an issue with the use of relationships in Power BI Desktop. I create all my queries and there is no problem but when I use the relationships I start having problems randomly when I try to add new relationships, perform DAX functions or even edit the queries. Usually the problem is that the modification is not done and it shows a problem regarding the server or a general problem with BI. The following is the model that I have in Power BI Desktop (Not finished yet because of that problem):

If I try to make any modification the following happens some times and some times does not. Lets say I try to upload the address of a file tha I have changed so that I have the information of the query available again.

Power BI starts loading and suddenly it throws a series of error messages. The first says tha there was a problem connecting with the server (I have checked that it is not the case since without those relationships the change that I am performing works well), then it says there is a problem with BI, after that another error and most of the times the software gets stuck:

 

 

This happens most of the times. And as I have mentioned when I don't have any relationships the modifications works well:

And lets say now that it worked I try to use the relationships again. When trying to create them again it throws error messages again. Here it i saying that USERRELATIONSHIPS can only be used whit the two columns related, but the error does not make sense since I was building the same relationships that I had in the first pic that I showed here and I did not change any of the DAX functions.

Can you please help me? I am pretty new in Power BI and maybe I am missing something when using relationship. Is there anything that I am skipping or any best practices that can guarantee they work?

Regards,

Mauricio 

[v-qiuyu-msft]

Hi @lmannear,

As you already create relationships among tables, please uncheck below options then load the new table to data model to see if the same issue occurs: 

From the screesnshots, you are using the USERELATIONSHIP() function in DAX, right? If it does, please ensure there are some thing we need to note, see: https://msdn.microsoft.com/en-us/query-bi/dax/userelationship-function-dax

For manage relationships in Power BI, see: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Best Regards,
Qiuyun Yu