Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a dashboard with data fetching from strored procedures, when input value "current date(01-21-2021)" is given as paramenter in SQL.
I want my reports to reflect the current date data upon refreshing.
Please help me how can I achieve this
Any help is highly appreciated
refer if this can help
https://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269
Hi Amit,
Thanks for the reply, I tried to follow the first link and create a dynamic function but everytime I run the function new table is created in PowerBI I cannot always recreate my exisiting reports with this new table
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |