Forum Discussion
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
- parry2k
Super User
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.