Forum Discussion
how to pass parameter in Azure table Storage?
Hi Team,
How to pass Query parameter to URL of Power BI Service in which the data is imported through "Azure table Storage".Please find the below URL , Table Name,Column name
URL : https://app.powerbi.com/groups/me/reports/ReportSection?
Azure Table Name : tablename
Column name : UserID
Please help !how to pass "USERID" parameter to power bi report and get user specific report in Power BI Service.
Thanks in Advance !
10 Replies
You could use standard query parameters to do this potentially if it is OK that each user would have to set this parameter to their user id. Otherwise, perhaps ImkeF knows of a way to grab the user id autmagically in M code.
Unfortunately, there is no native M-function to grab the user id.
But one should keep in mind, that this wouldn't work as a security, as the M-code could always be manipulated.
Thanks ! But I need how to pass the column "USERID" as a Query parameter to filter the Power BI URL and also to get the User specific report .
For Example : Let us assume an example for "Azure Sql Server", below is the Power BI URL to pass the "USERID as the Query parameter in the URL which contains
Table Name : tablename
Column name : USERID
value : '[email protected]'
https://app.powerbi.com/groups/me/reports/ReportSection?filter=table name/USERID eq '[email protected]'the above URL is perfectly filtering the report with respect to "USERID", since the Power BI data is imported from "Azure SQL Server"
For Example : Let us assume an Example for "Azure table Storage" ,below is the Power BI URL to pass the "UserID" as the Query parameter in the URL which contains:
Table Name : tablename
Column name : UserID
value : xyz@abc.com
https://app.powerbi.com/groups/me/reports/ReportSection?filter=tablename/UserID eq '[email protected]'
the above URl is not filtering the report with respect to "UserID" .Since the Power BI data is imported from "Azure table Storage."Please help !
Thanks ! But I need how to pass the column "USERID" as a Query parameter to filter the Power BI URL and also to get the User specific report .
For Example : Let us assume an example for "Azure Sql Server", below is the Power BI URL to pass the "USERID as the Query parameter in the URL which contains
Table Name : tablename
Column name : USERID
value : '[email protected]'
https://app.powerbi.com/groups/me/reports/ReportSection?filter=table name/USERID eq '[email protected]'the above URL is perfectly filtering the report with respect to "USERID", since the Power BI data is imported from "Azure SQL Server"
For Example : Let us assume an Example for "Azure table Storage" ,below is the Power BI URL to pass the "UserID" as the Query parameter in the URL which contains:
Table Name : tablename
Column name : UserID
value : xyzabc.com
https://app.powerbi.com/groups/me/reports/ReportSection?filter=tablename/UserID eq '[email protected]'
the above URl is not filtering the report with respect to "UserID" .Since the Power BI data is imported from "Azure table Storage."Please help !
