Forum Discussion

WimVan's avatar
WimVan
Icon for Helper I rankHelper I
7 years ago
Solved

Relationship problem between date columns from 2 tables

I have 2 tables: - 1 table "SubprojectsAll", loaded from sql via directquery, contains a date column named "Date last primary proposal revision"  (formatted in Power BI as date)   - 1 ...
Need Help
  • tex628's avatar
    tex628
    7 years ago

    And furthermore, it has to be done in the query editor. Does not work if you attempt to do it from the normal modelling pane!

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

I'm pretty terrible when it comes to SQL :-) But if you can upload a version with with import connectivity, i can take a look at that one instead. 

WimVan's avatar
WimVan
Icon for Helper I rankHelper I
7 years ago

I made a csv from the sql data.

 

Then imported in power bi.

When I try to change the type of the date column to "Date" I get following error: