I am trying to build a model, but on some of the relationship joins it will not let me set the Assume RI, because it is disabled, although I do know there is RI between these tables as one is a Foreign Key to another, can any one help. I can set RI for 3 relationships but not for all of them and when I try to pull a field into my Visualisation from one of the none RI set tables, I am getting an error saying there are too many records
Just started using Power BI, but do have experience of other toolsets
I would suggest you have a look at below articles.If you need further help,please share the sample file and your expected output.You can upload it to OneDrive and post the link here.Do mask sensitive data before uploading.
You can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery.