Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning. I have the following R code that I run for "Get Data" in Power Query (before working with Power BI Desktop):
...
username <- readline(prompt = "username = ") ; password <- readline(prompt = "password = ")
....
The part shown is where Power Query gives me an error, as it does not let me request data from the user through the "readline" function. Therefore, my question would be whether it is possible to request data from the user when running an R script in Power Query (either through that function or any other). Thanks a lot.
Solved! Go to Solution.
Yes. You would need to create two text parameters in the query editor, and then concatenate them into your R script. If you then save the pbix as a pbit (template file) and send that to your users, they would get prompted to enter username and password when they open it. They would want to be careful not to share the pbix files they generate as it would contain their credentials.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Yes. You would need to create two text parameters in the query editor, and then concatenate them into your R script. If you then save the pbix as a pbit (template file) and send that to your users, they would get prompted to enter username and password when they open it. They would want to be careful not to share the pbix files they generate as it would contain their credentials.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Wow! That's great. Thanks a lot. I have tried this and works correctly. And, if it's possible, I would like to ask you another aspect. Is there any possibility to prevent the user from saving their credentials (parameters) in the template? I need this to avoid what you say, the fact that the client can share the .pbix with its API keys.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |