Changing Data Soucrce Dynamically And Pass Session Values To Power BI Chart

[onbabu]

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.

[Eric_Zhang · Accepted 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.

[Anonymous]

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.