Accessing Query Editor data in Power BI service

[ayushqralgroup]

Hi All,

We are importing data from SFDC objects into our Power BI Desktop. After importing all the data, we apply certain filters on rows and columns in Query Editor and this filtered dataset forms our final table in the data model. We then publish the report to PBI service.

Our question is - Is there any way a Power BI service user can access the unfiltered data of the SFDC object present in the Query Editor? Our main concern is that the end user (accessing reports in Power BI service) should only see the filtered rows in the table of our data model and not the complete data set, either simply or by hook & crook. 

Please let me know if you need additional information. Thank you!

Regards,

Ayush 

[v-piga-msft · Accepted solution]

Hi @ayushqralgroup, 

If I understand your scenario correctly that you created a report with the SFDC which has been filterd data in Query Editor, then you publish the report to Power BI Service. You have concern that if the end user could have access to the complete data source which has not been filtered in Query Editor in Power BI Service.

Actually, If end user do not have the edit permission of the report, they cannot have access to the dataset and the underlying data source.

If your end user have the edit permission of the report, so they could have access to the dataset of the report and may could  download the report as pbix. By my test, for some datasource which don't need crendential, if the end user download the pbix, they could access to the query editor so they could see all the options setps for the datasource in query editor. 

For your scenario, it seems that if you connect SalesForce data source, you need to enter your credential, so when end user download the pbix from Power BI Service, they should be asked for enter the crendential to see all the data in Query Editor.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @ayushqralgroup,

Have you solved your problem?

If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @ayushqralgroup, 

If I understand your scenario correctly that you created a report with the SFDC which has been filterd data in Query Editor, then you publish the report to Power BI Service. You have concern that if the end user could have access to the complete data source which has not been filtered in Query Editor in Power BI Service.

Actually, If end user do not have the edit permission of the report, they cannot have access to the dataset and the underlying data source.

If your end user have the edit permission of the report, so they could have access to the dataset of the report and may could  download the report as pbix. By my test, for some datasource which don't need crendential, if the end user download the pbix, they could access to the query editor so they could see all the options setps for the datasource in query editor. 

For your scenario, it seems that if you connect SalesForce data source, you need to enter your credential, so when end user download the pbix from Power BI Service, they should be asked for enter the crendential to see all the data in Query Editor.

Best  Regards,

Cherry