Forum Discussion
Refreshing on PBI Service creates a problem with a relationship
The process I have just undergone is : 1. Create a .pbix on desktop that is connected to a SharePoint folder. 2. Test the refresh on desktop (success) 3. Upload .pbix to PBI service 4. Test ...
What problem are you facing in the service? Are the reports not getting filtered?
Yes, anything filtered by the link table gives an error, although i would not expect the problem to be limited to just filtering but anything that uses a relationship between tables.
This is the error message i get on 95% of the visuals in the report :
The query referenced a relationship between 'Table1'[COLUMN1] and 'Table2'[COLUMN1], which depends on a column that is not in a valid state.
Please try again later or contact support. If you contact support, please provide these details.
Thanks again