Hi, I am trying to add dataflows to a datamart, however when loading up the data to the datamart, I am getting an error that my date column is not a valid date/time field. Please see error belo...
Ok I think I found an easy work around. I was having the exact same problem with date columns not working due to the originals being non-US region. You also can't directly modify the table because it is a linked entity.
You can get around this using the method mentioned here: How to modify a linked entity in Power BI dataflows - RADACAD
Put Simply:
- Create a new table as a Blank Query
- enter just one line "= PowerBI.Dataflows()"
- Right-click on the Query in the queries pane, and UNSELECT "Enable load"
- Right-click on the Query in the queries pane, and select "Reference"
- In the new query, Navigate to the Workspace/Dataflow/Table that you want
- Repeat steps 4-5 for as many tables as you want.
It's very odd that this works, seeing as it seemingly is not any different to just loading the table from Dataflow natively