Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anmolgan
Post Prodigy
Post Prodigy

How to Pull data from SAP-BW

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!!!!

1 REPLY 1
v-lili6-msft
Community Support
Community Support

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.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-b...

https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

 

Best Regards,

Lin

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.