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 o...
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

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

    • dpombal's avatar
      dpombal
      Post Partisan
      7 years ago

      Hi , after Removing relationships,

      problem still persists....

       

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