Forum Discussion
Error Message (Blank Values)
If you go in the Query editor and check the column profile?
In this example I have a table with 1100 rows, first 1000 are ok. I the column distribution you'll find no blanksHowever, when switching to full dataset the blank comes out int he profile:
Perhaps you're experiencing something different, but it's already a good check of your data.
Did you select the correct columns to join on in the merge? How do you define a blank for a text colum?
I changed it to the entire dataset and I do see that there is one empty row... How do I handle this?
I removed the empty part, and it seemed that I was able to merge the tables without any problems. Now, I am asking you if I merged the tables, it should be refreshed every morning that I set up the data connections (the DailyTicket small dataset is automated), and the MainSet table is not automated (but still connected to SharePoint). I just want to make sure that the small dataset will update the main table by updating rows or adding new tickets to the main table. Does that approach make sense or is there a better way to do it?
If I understand that setup, you're now just merging the small table to the main table in PowerBI to get a complete view on all tickets.
This doesn't move data across, just gives you a merged view of both tables. Each time you refresh the dataset (can be scheduled in the morning) you will have a merged view on that data.
If you want to modify the Main table, you would not use PowerBI, but a dataflow for example to do so, so the changes are persisted in the main table and you can clear out the small table.
You would want to have a separate process that manages the daily changes table and one that merges those daily changes into the main table at the end of the day.