Forum Discussion
Using filtered data from Azure DB in PowerBI
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.
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.
2 Replies
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-biHi 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.
