Forum Discussion

telesforo1969's avatar
telesforo1969
Icon for Helper V rankHelper V
11 months ago
Solved

Create a date column based on two numeric fields in DirectQuery mode.

I have a table connected via DirectQuery to Power BI, and I have a numeric field (periodo) and a numeric field (Anio). With these values, I need to create a date field for data analysis. I am attachi...
Need Help
  • KarinSzilagyi's avatar
    KarinSzilagyi
    11 months ago

    Ah, sorry - I missed that you're using DirectQuery mode. 
    In that case you could try to add the column via SQL through the advanced connection settings instead:

    Then remove the Navigation-step below your Source-Step.

  • KarinSzilagyi's avatar
    KarinSzilagyi
    11 months ago

    Hi telesforo1969, according to the error-message the table doesn't exist in the database with that name. Are you sure that your is in the dbo-Schema? 

    You can confirm which schema your table belongs to if you connect normally via the SQl-connector and check the code in the "Navigation"-step (or by checking it directly on the SQL Server if you can access it)

telesforo1969's avatar
telesforo1969
Icon for Helper V rankHelper V
11 months ago
I get the following error. I've checked my table name thinking that could be the error, but it's not.

 

KarinSzilagyi's avatar
KarinSzilagyi
Icon for Super User rankSuper User
11 months ago

Hi telesforo1969, according to the error-message the table doesn't exist in the database with that name. Are you sure that your is in the dbo-Schema? 

You can confirm which schema your table belongs to if you connect normally via the SQl-connector and check the code in the "Navigation"-step (or by checking it directly on the SQL Server if you can access it)

  • telesforo1969's avatar
    telesforo1969
    Icon for Helper V rankHelper V
    11 months ago

     

    Thank you very much, with your support I have converted two numeric fields to date in

    DirectQuery Mode