Power BI CDS - Different Data for Different Users on a Shared MS Forms PRO Survey
When we connect to a common data service (CDS) using credentials of user 1 who sent out the survey and has created the survey, they can see all the data.
However, user 2, who the survey is shared with, cannot see the data, even who was invited in the msfp tables which is used for storing the surveys and the survey data.
Tables in question:
this is both, under entities and system area’s and both give no data accordingly. We are using MS Forms Pro, and Power BI Pro (desktop) to pull in the data. We also tried through Power BI Data Flows, and that didn’t work either.