Forms Pro to Power BI via Common Data Service - can only see users own Surveys?

%3CLINGO-SUB%20id%3D%22lingo-sub-1102898%22%20slang%3D%22en-US%22%3EForms%20Pro%20to%20Power%20BI%20via%20Common%20Data%20Service%20-%20can%20only%20see%20users%20own%20Surveys%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1102898%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20successfully%20connected%20Forms%20Pro%20through%20to%20Power%20BI%20via%20the%20Common%20Data%20Service%2C%20by%20following%20the%20steps%20described%20here%20(they%20are%20a%20little%20out-of-date)%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2Fblog%2Fcds-for-apps-powerbi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2Fblog%2Fcds-for-apps-powerbi%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20after%20reviewing%20the%20data%20pulled%20from%20entities%20like%26nbsp%3B%3CSTRONG%3Emsfp_survey%2C%26nbsp%3B%3C%2FSTRONG%3Eit%20seems%20I%20can%20only%20retrieve%20Forms%20Pro%20data%20for%20the%20user%20who%20is%20signed%20in%20(to%20the%20Power%20BI%20CDS%20connection)%3F%20I%20was%20expecting%2Fhoping%20to%20get%20the%20data%20for%20all%20the%20surveys%20that%20have%20been%20shared%20for%20editing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBTW%20it%20seems%20others%20are%20seeing%20the%20same%20issue%20wrt%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FDesktop%2FPower-BI-CDS-Different-Data-for-Different-Users-on-a-Shared-MS%2Fm-p%2F810976%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FDesktop%2FPower-BI-CDS-Different-Data-for-Different-Users-on-a-Shared-MS%2Fm-p%2F810976%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1102898%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1278940%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20Pro%20to%20Power%20BI%20via%20Common%20Data%20Service%20-%20can%20only%20see%20users%20own%20Surveys%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1278940%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408377%22%20target%3D%22_blank%22%3E%40Mike_Honey%3C%2FA%3E%26nbsp%3B-%20I'm%20seeing%20the%20same%20issue%20here.%26nbsp%3B%20I%20haven't%20created%20any%20forms%20personally%20and%20so%20see%20no%20data%20at%20all%2C%20even%20though%20another%20user%20has%20created%20and%20shared%20a%20form%20with%20me.%26nbsp%3B%20I'm%20looking%20in%20the%20msfp_*%20tables%20in%20the%20CDS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20manage%20to%20resolve%20this%20yourself%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I've successfully connected Forms Pro through to Power BI via the Common Data Service, by following the steps described here (they are a little out-of-date):

https://powerapps.microsoft.com/en-us/blog/cds-for-apps-powerbi/

 

But after reviewing the data pulled from entities like msfp_survey, it seems I can only retrieve Forms Pro data for the user who is signed in (to the Power BI CDS connection)? I was expecting/hoping to get the data for all the surveys that have been shared for editing.

 

BTW it seems others are seeing the same issue wrt:

https://community.powerbi.com/t5/Desktop/Power-BI-CDS-Different-Data-for-Different-Users-on-a-Shared...

1 Reply

@Mike_Honey - I'm seeing the same issue here.  I haven't created any forms personally and so see no data at all, even though another user has created and shared a form with me.  I'm looking in the msfp_* tables in the CDS.

 

Did you manage to resolve this yourself?