Forum Discussion
Avoiding 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
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
That worked!
awesome, thanks, you've really helped me here!