Forum Discussion

rpagar's avatar
rpagar
Helper I
5 years ago

Unable to see data while using reference table

Hi All, I am using data source as Sales Force Reports. It has table "User Logins" with User Name and Login Date Columns. In the same PBI file i have created "Date" table as a reference table which c...
Need Help
rpagar's avatar
rpagar
Helper I
5 years ago

That's not helping out. Thanks for reply. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi rpagar ，

Which data type [Date] field in Date table and Field [Login Date] in table User Logins are respectively set in Power BI? They are set as Date or other date type? Whether their date type and format are same?

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

  • rpagar's avatar
    rpagar
    Helper I
    5 years ago

    for both tables i am using.."Date" as data type and date format is "Date-Month Name- Year"..."19-Oct-20". 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi rpagar ,

      It is strange. Could you please provide your sample pbix file (exclude sensitive data) in order to make troubleshooting?

      Best Regards
      Rena
      Community Support Team _ Rena Ruan
      If this post helps, then please consider Accept it as the solution to help the other members find it more.