Forum Discussion

dpombal's avatar
dpombal
Post Partisan
7 years ago
Solved

Switching from Direct Query to Import

 

 

I am having an issue while switching a report with Direct Query to Import

 

Column 'Import' in Table 'Fact_Statistics' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

 

 

Import column is not the Primary Key, can the issue be caused by some key field not existing on One side?

 

 

Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi dpombal,

    I could reproduce your problem, if you want to create relationship between the two tables, you could delete the orginal relationship firstly, then try to import your data table and create the relationship, now you could get the result.

     

     

    Hope it could help you.

     

    Regards,

    Daniel He

4 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi dpombal,

    I could reproduce your problem, if you want to create relationship between the two tables, you could delete the orginal relationship firstly, then try to import your data table and create the relationship, now you could get the result.

     

     

    Hope it could help you.

     

    Regards,

    Daniel He

    • dpombal's avatar
      dpombal
      Post Partisan
      7 years ago

      So Starting with Direct Query,  which is my usecase.

      1. Direct Query Report with relationship between A and B

      2. Delete relationship between A and B

      3. Switch to Import

      ok?

      • v-danhe-msft's avatar
        v-danhe-msft
        Microsoft Employee
        7 years ago

        Hi dpombal,

        Yes, you could try this and if have any problems, please let me know.

         

        Regards,

        Daniel He