Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My data is coming in from the google api and a static excel doc. It appears to be out of alignment a la a printing press? I know this sounds weird. The reason it's a problem is because it introduces blanks into my data set with means I can't create any joins. The blanks are not 'unique values' and all.
Has anyone seen this or know a fix? I've tried refreshing and disconnecting from the API and reconnecting.
I was hoping it was just a UI issue, but the joins not being allowed through makes me think otherwise. Any help?
Note, the ROW line starts to become more and more out of alignment until it goes full circle and a blank is introduced.
In Query Editor, click the drop down arrow for one of the columns and select "Remove Empty".
Thanks for the reply. I tried that and creating a separate table that is just distinct values. I sent the file to a friend and they had no issues. Uninstall and reinstall maybe?
z