Forum Discussion
Power BI Dataset field format different than direct source format
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.
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.