Forum Discussion

rbs_analyst's avatar
rbs_analyst
Frequent Visitor
9 years ago

Unable to create relationship

I have three tables with a colum each for "Pagenames". All the three "Pagenames" dataset are not similar throughout. I would like to have visualizations for all three tables on a single page and cont...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi rbs_analyst,

 

If I understand correctly, three tables contains the same column "Pagenames" and after you append queries and remove duplicates and empty rows, data view tab display the data not same to the Query Editor, right?

 

Based on my test, the Data view tables should be the same as the one in Query Editor.

 

1. Assume three tables like below:

 

 

2. Append three tables as a new table.

 

 

3. Check the "Pagenames" column in the new table, click Remove Duplicates and Remove Blank Rows.

 

 

4. Order the "Pagenames" column.

 

 

5. Apply the changes to report.

 

 

In your scenario, please verify you have applied the changes by clicking Apply, or you can click the Refresh button in the report. Please take a look at attached .PBIX file.

 

Best Regards,
Qiuyun Yu

 

 

  • rbs_analyst's avatar
    rbs_analyst
    Frequent Visitor
    9 years ago

    Hi v-qiuyu-msft,

     

    I have applied the queries. To verify if the queries are getting applied, I also added a query to rename column and found that the column names remain the same in the data view tab. I have also tried refresh.

     

    My dataset is huge and consists over 100 million datapoints. Would this occur because of memory constraints? My PC has a 4GB RAM.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi rbs_analyst,

       

      As you mentioned there are 100 million datapoints, can you filter the data to keep less rows in query editor then apply the changes to see if the same issue occurs?

       

      Also the minimum RAM to run the desktop is 1 GB, I think 4G RAM is enough.

       

      Best Regards,
      Qiuyun Yu