Forum Discussion
Helper IAvoiding free text credentials in Power BI query.
Thanks for your reply.
"Get data from the source and don't load the data in the report, just use it to log in the API. That way you are not adding text at PowerBi. "
I am not sure how I would do this, how would Power BI 'know' I had authenticated?
Let me write an example. If you create a table at excel sharepoint with the following columns:
clientid | clientsecret | user | password
Get data from the excel file. Then you can get the string of each column to authenticate at the API. You are not writing text at the powerbi literally and you can get data from the API.
Once you have connected to the API and before close & apply, click on the excel and "don't load" the table. That way it won't be visible for the model.
I hope that make sense
Super UserHi. If the problem is about inserting the password manually at PowerBi, you could just save the credentials in a file at sharepoint, file at blob storage or even a database. Get data from the source and don't load the data in the report, just use it to log in the API. That way you are not adding text at PowerBi.
If you want to deep dive in the scenario, you could try a custom connector for connecting to Azure Key Vaults. That might require a little more experience like working with custom connectors and creating a Key Vault, you can check it here: https://www.bibb.pro/post/securing-your-api-power-bi-data-with-azure-key-vault#:~:text=Using%20Azure%20Key%20Vault%20in,via%20Power%20BI%20M%20Code
I hope that helps,
Helper IThanks for your reply.
"Get data from the source and don't load the data in the report, just use it to log in the API. That way you are not adding text at PowerBi. "
I am not sure how I would do this, how would Power BI 'know' I had authenticated?
- ibarrau
Let me write an example. If you create a table at excel sharepoint with the following columns:
clientid | clientsecret | user | password
Get data from the excel file. Then you can get the string of each column to authenticate at the API. You are not writing text at the powerbi literally and you can get data from the API.
Once you have connected to the API and before close & apply, click on the excel and "don't load" the table. That way it won't be visible for the model.
I hope that make sense
- richardc1
That worked!
awesome, thanks, you've really helped me here!