question

CodyWimmer-7258 avatar image
0 Votes"
CodyWimmer-7258 asked ·

Importing SAP BW using a Specified Date Range

I am trying to update a Import query in SAP BW Query in Power BI. I was trying to use the star schema approach but every time I add a new dimension it asks for a date.

Every month we want to add the new month and drop off the old. For example we start with Jan, Feb, Mar, then we want to go to Feb, Mar, Apr.

Is there an easy way to do this without having to rebuild all the data.

We have thought about importing every month, but that still does not help us when a new month is added to our BW data.

Basically, we want a way to refresh out query with restricted dates without having to rebuild it. Is there a simple way to do this?

not-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered ·

QnA currently supports the products listed here (more to be added) Better to reach out to subject matter experts in dedicated forums over here.


https://community.powerbi.com/


--please don't forget to Accept as answer if the reply is helpful--


Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management


Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.




· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.