cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
anthonyloh Frequent Visitor
Frequent Visitor

Date field from SAP BW Query coming in as text

Hello,

 

I am trying to use the date functionality in Power BI with the date fields coming across from my BW query but they are coming across as text fields and I can't change the format in Power BI to a date. When I highlight the Calendar Day field, the data type options in the toolbar are greyed out. Also, I tried but can't seem to create a new measure that converts the text in Calendar Day to a true date value. I'm still new to DAX but I did find the DATEVALUE function, however I can't seem to refrence the Calandar Day field in my formula. Ultimately, I want my power BI report to show yesterday's date so I need a dynamic date filter.

 

Has anyone else come across this and how are you handling dates in your Power BI reports?

 

Thank you,

Anthony

8 REPLIES 8
v-danhe-msft Super Contributor
Super Contributor

Re: Date field from SAP BW Query coming in as text

Hi @anthonyloh,

Can you tell me which type your data is connected? Direct query or import? If former, I am afraid you could not format your row data, due to the limitation in DirectQuery and SAP Business Warehouse, you could refer to this link:https://docs.microsoft.com/en-us/power-bi/desktop-directquery-sap-bw#additional-modeling-restriction...

And there are many limitations with Direct query in Power BI Desktop, you could refer to this link:

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#implications-of-using-directquer...

I suggest you to modify your data type in your SAP Business Warehouse firstly, then you could use the Power BI to get your data again.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft Super Contributor
Super Contributor

Re: Date field from SAP BW Query coming in as text

Hi @anthonyloh,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

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

Re: Date field from SAP BW Query coming in as text

Hi Daniel,

 

My report is connected to SAP BW via Direct Query. My date field is already formatted as a date field in BW so there isn't anything more I can do on that end I think. I don't understand why I can't use a formula to create a new field with a formula that converts the text that I am getting from my date field into an actual date value.

 

Thank you,

Anthony

Nivedhitha Frequent Visitor
Frequent Visitor

Re: Date field from SAP BW Query coming in as text

"Date fields like calendar day, weeks months are not recognized as date fields: for Power BI those are text fields: no filters like today, current year etc. possible" we are using direct query, I've gone through your additional restriction document link but I need alternate solution, can you please help

Nivedhitha Frequent Visitor
Frequent Visitor

Re: Date field from SAP BW Query coming in as text

We are using direct query to connect to bw data, the date field extracted as text field. I've gone through the link you mentioned still I need an alternate solution and also I've a doubt can we use Transform column query in advance editor

pbi_leaner Visitor
Visitor

Re: Date field from SAP BW Query coming in as text

Did you get a solution to the problem? We have the same problem!

sjvz Frequent Visitor
Frequent Visitor

Re: Date field from SAP BW Query coming in as text

need this to enable incremental refresh  ...any luck ...anybody 

sjvz Frequent Visitor
Frequent Visitor

Re: Date field from SAP BW Query coming in as text

i pulled two different date fields in the query and noticed that one does come up as a date and the other one comes up as a text. Both are created as date fields in BW , however the one that does come up as the date field is under the time dimension and the other one is not.  i am not sure if that has anything to do with it. 


@sjvz wrote:

need this to enable incremental refresh  ...any luck ...anybody 



datecapture.JPG

 

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 476 members 4,442 guests
Please welcome our newest community members: