Forum Discussion
Login credentials not known by user
If I understand correctly, you want to enable users to connect to a database without allowing them logins?
Do they all have power bi licences (pro will do).
You could publish a master dataset to the power bi service that contain the relevant data (either in import or direct query mode) and users would then connect to that instead.
Hi isstefanjud ,
Unfortunately, this will lead to privacy disclosure, which power bi will not do, and pbix will not carry the credentials of local connection to the data source.
If they just view and edit the report(not query data source), you can use the import mode to share the pbix, and they will not be asked for Oracle login credentials.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hej
thank you for the quick reply. Unfortunately the idea is to have neither PBI licenses nor PBI Online for the simple version of the reporting. It is meant to offer a simple tool for the end user to create simple reports in PBI directly with our Oracle database. In the enterprise version we use SSAS and PBIOnline, which offers methods like a master dataset or a fixed user for connection to the database.
The situation is as follows: we deliver a software package. Newly it should contain a reports.pbix file which can be opened by the end user. The file contains simple dashboards and connects to an Oracle database.
Now, the user will not know the database (without a proper Oracle Client the tnsnames.ora is missing, which makes the connection string very complex) and will not a have a user/password.
Now, it would be good to provide:
- Database Connection String
- User Credentials
directly with the file we provide within our software package. As we have few but select customers, it would (if needed) be possible to edit these files before the deploy them to our users.
Community SupportHi isstefanjud ,
Unfortunately, this will lead to privacy disclosure, which power bi will not do, and pbix will not carry the credentials of local connection to the data source.
If they just view and edit the report(not query data source), you can use the import mode to share the pbix, and they will not be asked for Oracle login credentials.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.