Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am Developing Power BI Charts by using Power BI Desktop, Sql Server db, I have some requirements such as
1. How to give data souce sql db connection string(for example in .net we can sepecify connection string in web.config file), and get data dynamically.
2. Is there any possible way to pass session values to Power BI Charts. i.e In my application I have CompanyID in session, I need to get chart with values based on Session CompanyID.
Can any one help me in these issues.
Thanks In advance
Narendra.
Solved! Go to Solution.
@onbabu wrote:Hi,
I am Developing Power BI Charts by using Power BI Desktop, Sql Server db, I have some requirements such as
1. How to give data souce sql db connection string(for example in .net we can sepecify connection string in web.config file), and get data dynamically.
2. Is there any possible way to pass session values to Power BI Charts. i.e In my application I have CompanyID in session, I need to get chart with values based on Session CompanyID.
Can any one help me in these issues.
Thanks In advance
Narendra.
->1
In Power BI desktop, you can set paratemers and apply them to the Power query connection string. Check
Deep Dive into Query Parameters and Power BI Templates
Power BI Tutorial: How to Parameterize Connection Variables in Power Query
While after publishing, namely in Power BI Service, there's no way to change the connection string any more.
->2
Regarding "passing session values to Power BI Charts", AFAIK, Power BI Service REST APIs doesn't accept that "CompanyID in Session" while Power BI Embeded provides more flexibility and Row level security with Power BI Embedded seems able to handle your scenario.
@onbabu wrote:Hi,
I am Developing Power BI Charts by using Power BI Desktop, Sql Server db, I have some requirements such as
1. How to give data souce sql db connection string(for example in .net we can sepecify connection string in web.config file), and get data dynamically.
2. Is there any possible way to pass session values to Power BI Charts. i.e In my application I have CompanyID in session, I need to get chart with values based on Session CompanyID.
Can any one help me in these issues.
Thanks In advance
Narendra.
->1
In Power BI desktop, you can set paratemers and apply them to the Power query connection string. Check
Deep Dive into Query Parameters and Power BI Templates
Power BI Tutorial: How to Parameterize Connection Variables in Power Query
While after publishing, namely in Power BI Service, there's no way to change the connection string any more.
->2
Regarding "passing session values to Power BI Charts", AFAIK, Power BI Service REST APIs doesn't accept that "CompanyID in Session" while Power BI Embeded provides more flexibility and Row level security with Power BI Embedded seems able to handle your scenario.
Eric did you test it before mark it as solution; as its does not support direct query; if you use and the second post more aligned to power query solution; i was unable to acheive it through powerbidesktop with out lot of tweaks.
Can you provide better solution link which caters PowerBI rather PowerQuery.
User | Count |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
19 | |
4 | |
3 | |
1 | |
1 |