Forum Discussion
Advocate IDate Format Direct Query
I found this........ it worked........
https://community.powerbi.com/t5/Desktop/Unable-to-alter-number-formatting/td-p/38134
Resolver IIf I'm in directQuery mode, open the Query Editor I'm able to change a column Data Type from Date/Time to Date.
Advocate I
After changing the data type
- dtartaglia
I initially had: "Allow unrestricted measures in DirectQuery" enabled. I disabled it and changing the format worked. I wonder if the setting didn't really change? If you click File->Options and settings->Options->DirectQuery and enable: "Allow unrestricted measures in DirectQuery", can you change the format? My test source is a SQL view.
Hi,
I am using recent version. i can find only one option "Treat SAP like relational database".
I enabled it.
Even i didnt get chance to edit it. My column is in text format , i wanted it to be date formate witout time in it. please help me with this.
One More help. How to change from import mode to direct query mode without affecting data?
Thanks
Sai
Hi,
Are you trying to import SAP data using import mode? I am assuming you first loaded the data without transforming and still you are not able to see "Data type" in Data modelling tab even after selecting the table and column you would like to change the data type format. Can you please let us know the error that you are reciveing.Please find the below screenshot
I don't think so we can change from import mode to direct query mode without affecting data after bulding the dashboard. We have to select this option while building the dashboard.
- Hasan
you might want to sue the modeling option in home page. I jsut tried and it is working for me
- dtartaglia
aarikc17 are you on the lastest version of BI Desktop?