Hi I am getting the following error on the created column when i am refreshing the data. I did not have nay issues before the refresh.
Following is the code snippet
Billable = if(
Following is the error
This expression refers to a Relationship object named '902a1ae2-e95d-420e-9f24-eae5303c57d8', which has an error.
Can some one help me in debugging this issue?
I also get the same error. There was an calculated table named X with SUMMARIZECOLUMNS dax function connected to an imported table named Cities's CityName column. I think the problem began when i change the calculated table function and droped the CityName column the column of X table without removing the relation. And now even that simple code gives error.
Whenever there is an error in the primary key (of any table related to your table and not only the table in contention) this error pops up. Please ensure all the relationships with the Task and Jobs Table are valid. Whenever a cross table reference is made PBI checks the validity(no errors in the primary key) of all the relationships with that table.
To be totally safe, Click on Modelling and then Manage Relationships, Check the validity of every relationship in this menu so that Relationship object based errors are avoided.
I am experriencing similar issues only if the report is using an "On-premises data gateway". While using the personal gateway mode my report and refreshing seems to work as intended.
Has anyone managed to solve this issue in any way?
I have the same kind of error
"his expression refers to a Relationship object named '31445cef-2400-49fa-8c32-a0a250a394ce', which has an error."
I guess that is referred to this DAX:
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.