Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
Fairly new to Power BI and I was wondering if there is a way to add the connecting username to the connection string.
Source = Sql.Database("DB", "Table", [Query="#(lf)EXECUTE [dbo].[PowerBI_Test] @username = 'Login Username here'#(lf)"])
I want to pass the username to a stored procedure.
Thank in advance for any help
Hi Adam, Did you get this working?
User | Count |
---|---|
8 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |