Forum Discussion

BIsteht's avatar
BIsteht
Icon for Helper III rankHelper III
5 years ago
Solved

Power BI Dataset field format different than direct source format

I have a date table in the Power BI Dataset I am connected to. The Date field in that model is formatted as Date in the Dataflow where it was created. It is also formatted as a Date type when I work ...
dataflow
Need Help
  • BIsteht's avatar
    BIsteht
    5 years ago

    StefanoGrimaldi 

    Thanks for the response. What you point out is clear - it makes sense that I cannot edit the dataset when live connected. The issue, here, is this:

     

    • Type at source is Date (This is a dataflow with the Date field set as type Date). When I live connect to the dataflow in my dataset, the type is as expected - Date.
    • Type is Date/Time when I live connect to the dataset containing this dataflow.

    So, you can see the issue. I already have this defined correctly in the dataflow. As long as I connect directly to it the type is as expected. But when I live connect to the dataset containing this dataflow for some reason that column type is coming in as Date/Time.

     

    Long story short - the field is defined correct at the source but is returned as a different type when I connect to the live dataset it is published to.

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi BIsteht ,

 

I have reproduce your issue. I would report it to develop team. If there is any update , I will post it here. I also suggest you Please report this as an Issue using issues.powerbi.com.  first check to see if it has already been reported.  

 

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

 

Best Regards,

Dedmon Dai