Forum Discussion
Connecting Power BI with Datasphere
Hi,PowerBIUser2026 .I am glad to help you.
My understanding of this issue is as follows:
the user can only see the data in the report that he/she has access to, (if a gateway connection is set up, the report is accessed using the data source credentials set up in the gateway connection as authentication)
Therefore, if the report producer creates a space that only the corresponding user can access, and uses this part of the data as the data source for the report, then in the future, when the report is successfully produced, published to the service, and the data source credentials are successfully configured, and then the user accesses the report after the report is refreshed, he or she will only be able to see the report data that he or she can access with the identity configured in the gateway connection's data source access credentials. You can also set up RLS to ensure that only certain users have access to some data to realize data protection.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft LearnConsuming data from SAP Datasphere into Power BI v... - SAP Community
If you are using the ODBC method and the connection mode is import, you need to configure the gateway connection and Scheduled Refresh for the report.
Configuring the data source credentials (what authentication method to use to access Datasphere) will be the key to solving your problem.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So if I create a space in Datasphere and assign a user to this specific space and connect it to Power BI, then the person will only see the data in this space?
Hi,PowerBIUser2026 .I am glad to help you.
My understanding of this issue is as follows:
the user can only see the data in the report that he/she has access to, (if a gateway connection is set up, the report is accessed using the data source credentials set up in the gateway connection as authentication)
Therefore, if the report producer creates a space that only the corresponding user can access, and uses this part of the data as the data source for the report, then in the future, when the report is successfully produced, published to the service, and the data source credentials are successfully configured, and then the user accesses the report after the report is refreshed, he or she will only be able to see the report data that he or she can access with the identity configured in the gateway connection's data source access credentials. You can also set up RLS to ensure that only certain users have access to some data to realize data protection.
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Consuming data from SAP Datasphere into Power BI v... - SAP Community
If you are using the ODBC method and the connection mode is import, you need to configure the gateway connection and Scheduled Refresh for the report.
Configuring the data source credentials (what authentication method to use to access Datasphere) will be the key to solving your problem.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.