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

You are importing using direct query, which means i cant see any of the data in the pbix file! I'm not certain if this could be the cause of the issue as im not too used to direct query myself! If you change the connectivity to import instead, does it work?

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

I had the same idea it could be related to directquery. But with import I have the same problem.

 

By the way the other link I provided you is a file to generate the sql table with data.

You are not familiar with sql?