Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Relationship problems with Sharepoint and Excel

Hi,

 

Im new using relationships in power bi. I have a custom table X that gets it's data from excel. I made a drill through page that whenever I right click a ABC a new page opens up with data cards such as 

 

location

date

number

 

location is being pulled from table x

I have a sharepoint list that has the information of project ABC date and number. How do I link that information so that whenever I drillthrough project ABC location, date, and number fill in based on what's on the sharepoint list?

 

I tried making a relationship like linking project name in sharepoint list to project name in table X but every time I drill through date and number are blank.

1 Reply

  • Anonymous it is very hard to understand what the issue is? If possible share pbix file with sample date, remove any sensitive information before sharing.