Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I ahve a simple question, I have a BEx query where I have start and end date parameter defined, whcih I use to fetch results for a start and end date, but can someone tell me what I have to do if I need to see live data in PowerBI Service?
For example I have a BexQuery which gives me start and end date parameter and I choose in start date 2017 JAN and 2019 JULY, and build my report and deploy it to the powerbi service, now lets say on 1st august since my end date is ending on 31st JULY I will not be able to any data for august right? Then How can I change my Bex Query from the PowerBI Service without go about buidling separate powerbi reports each month of the current month any thoghts or solution will be helpfull!!!!
hi, @Anmolgan
You could try to use parameter Function in edit queries, just edit parameter in power bi service
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://docs.microsoft.com/en-us/power-bi/service-parameters
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
Best Regards,
Lin
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |