Forum Discussion
Prompt user to provide the credentials
You can't have a dialog box in Power BI Desktop and Service.
The only option is to create two parameters UserName and Password and use them in your PowerQuery code. And once user wants to use your report he can go to Edit Parameters menu in Desktop and enter them.
See where located edit parameters in Desktop and Service - https://docs.microsoft.com/en-us/power-bi/service-parameters.
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups
Thank you for the reply.
I do have UserName and Password as parameter. While creating parameter if I make parameter as required, parameter has to have value at design time only. Later on power bi doesn't prompt for parameter input. Seems the parameter values are static in power bi.
It means that without providing any input user could see the report and which not good practise.
Moreover end user would be non-techi guys, so I do not wanted to drag them to edit the parameter values.
Please let me know if you have more pointers.
Thanks aagain !
Did you find an answer to this? I have the same problem.
