Using filtered data from Azure DB in PowerBI

[Anonymous]

Problem Statement - I have a Azure DB that has a column "ClientID" storing multiple values. I need to extract only the data with a particular clientID and create a PowerBI dashboard on that dataset which auto refreshes on new data entered in DB. Please suggest possible solutions.

For Example- At a time, only one clientID should be used in PowerBI dashboard.

Scan Date	ScanID	ClientID	Name
14-March	01	06418	Alan
14-March	02	07268	Barbara
15-March	01	07268	Barbara
18-March	01	07268	Barbara
18-March	02	06418	Alan
14-March	02	06418	Alan
18-March	01	07268	Barbara

The main ask - The DB gets updated daily and adds new entries and thus, I need the dashboard to update accordingly when I refresh the dashboard.

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous,

Is that you want something like this statement.

create view view_name as

SELECT [Scan], [Date], [ScanID], [ClientID], [Name] FROM table WHERE ClientID = "a particular clientID"

with check option

Automatically updated when you refresh?

You can get data from azure db with power query and set a parameter to dynamically get data. Or filter the table directly in power query editor. Then publish this report to power bi service and set scheduled daily refresh .

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Check if RLS can help

RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi